Forum Discussion

TROYDB's avatar
TROYDB
Regular Visitor
10 years ago

U2 Universe database ODBC connection

Hi,    I hope anyone can help I can't seem to connect to our Universe database using the U2 ODBC driver, the error I recieve:    "ODBC: ERROR [S1C00] [Rocket U2][U2ODBC][2301827]Driver not capabl...
arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi mi55cu,

 

The problem is that this driver doesn't support something we do, but there's a simple work around:

 

Go to "Get Data" > "Blank Query" and then type this to the formula bar:

= Odbc.DataSource("dsn=YOURDSNNAME")

(This disables hierarchical navigation)

 

Thanks

TROYDB's avatar
TROYDB
Regular Visitor
10 years ago

Hi Arify, 

 

Thank you , I now recive a new error : 

 

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [S1C00] [Rocket U2][U2ODBC][2301827]Driver not capable..'.

  • arify's avatar
    arify
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    That looks like the same error. Did it happen when you used Blank Query > Odbc.Datasource("dsnname") ? That's odd..

     

    Can you please send us a frown with traces when you're doing Blank Query > ... ?

     

    Thank you very much