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
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's avatar
    gemidriver
    Icon for Helper II rankHelper II
    8 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'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,

      • Karl-D's avatar
        Karl-D
        Icon for Helper I rankHelper I
        3 years ago

        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.