Forum Discussion
U2 Universe database ODBC connection
Helper IIHi
I can connect to my Universe data source via the ODBC connection and i can see my tables
When i select a table however i get the error
DataSource.Error: ODBC: ERROR [S1003] [Rocket U2][U2ODBC][2200285]SQL data type out of range.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=UniverseDev
OdbcErrors=Table
Super UserI 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,
- Karl-D
Helper I
Agreed. With older drivers, I was able to get each table individually using Advanced and entering a query.
With the newer drivers, 7.241.02.9004 10/17/2022 U2ODBC.DLL, I was able to use PowerBI normally, browsing and selecting tables from the database.
- gemidriver
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
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.
When you say that you can connect now with the 'newest driver', what driver are you referring to? Universe ODBC driver? Please show me the URL where I can download the latest driver. Thank you.
When you said that you finally connect using the 'newest' driver, what driver were you referring to? Universe ODBC driver? Kindly let me know where can i download the aforementioned driver. Thank you.
hello.. where can I get the newest driver?
- gemidriverYou need to login to the rocket software website
