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...
mi55cu's avatar
mi55cu
New Member
10 years ago

Hi,

 

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

 

Cheers

  • 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 :)

    • TROYDB's avatar
      TROYDB
      Regular Visitor
      10 years ago

      Hi Arify, 

       

      Thank you , I now recive a new error : 

       

      Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [S1C00] [Rocket U2][U2ODBC][2301827]Driver not capable..'.

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

        That looks like the same error. Did it happen when you used Blank Query > Odbc.Datasource("dsnname") ? That's odd..

         

        Can you please send us a frown with traces when you're doing Blank Query > ... ?

         

        Thank you very much