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...
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
8 years ago

I finally connect too. With the newest driver the error on the previous post are over.

 

I manage to get the data without selecting the table. I open the advanced options and write a SELECT * FROM TABLE.

 

Hope that help

Regards,

gemidriver's avatar
gemidriver
Icon for Helper II rankHelper II
8 years ago

can you please explain more?

i use this query

= Odbc.DataSource("dsn=UniverseDev", [HierarchicalNavigation=true])

and i can see the tables

how do i now write query to return data from specific table?

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    8 years ago

    Just add the query before connecting. Open de advance option:

    Write the dsn, add the query, then when you accept it should ask for credentials and the table will be returned.

     

    Regards, hope this helps. You can add it on power query too.