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

mi55cu's avatar
mi55cu
New Member
10 years ago

Thanks arify, I've conveyed this to our IT support. I think we operate on IBM's Unidata - will the solution be different in this case?

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

    It'll probably work, as long as there isn't another issue :)