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 capable." The same DSN works fine in Excel, any help?

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 helpRegards,

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.

Can you please send us a frown email with this error (On the top-left corner there's a smiley, you can see the frown button if you click the little down arrow right next to it)? If you can attach the trace files too (Options > Diagnostics > Enable Tracing, and while it's enabled, reproduce the error. Trace files will appear in the traces folder)? Thanks

Hi, Thank you for your help! I have sent the frown with the details.

Hi, We have the same problem and am interested to hear the solution/response Cheers

U2 Universe database ODBC connection | Microsoft Fabric Community

18 Replies

arify
Microsoft Employee
10 years ago
Can you please send us a frown email with this error (On the top-left corner there's a smiley, you can see the frown button if you click the little down arrow right next to it)?

If you can attach the trace files too (Options > Diagnostics > Enable Tracing, and while it's enabled, reproduce the error. Trace files will appear in the traces folder)?

Thanks
- TROYDB
  Regular Visitor
  10 years ago
  Hi,
  
  Thank you for your help!
  
  I have sent the frown with the details.
mi55cu
New Member
10 years ago
Hi,

We have the same problem and am interested to hear the solution/response

Cheers
- arify
  Microsoft 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
    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?
ibarrau
Super User
9 years ago
I have the same problem. Still can't connect ODBC driver. I solve this for now connecting the with R script throw ODBC driver.

The problem is that R script doesn't work with Enterprise - On premise Gateway. So i don't know what i am going to do when i finished my reports.

It sucks because udl file and R can connect throw the driver, but power bi can't.
Maybe is the 32/64bits driver or something like that.

Regards, hope someone get the solution soon.

P/D Odbc.DataSource("dsn=name") doesn't work.
- gemidriver
  Helper II
  9 years ago
  Hi
  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
  - ibarrau
    Super User
    9 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,