Forum Discussion

chefe's avatar
chefe
Helper II
10 years ago

Oracle ODBC connection fails ([HY004] [Oracle][ODBC]Invalid SQL data type <-25>)

Hi there,

 

I am trying to ODBC connect to an Oracle database, semi-successfully that is.. The connect "as-is" works. It is only when I try to fetch a table that I get this error (DataSource.Error: ODBC: ERROR [HY004] [Oracle][ODBC]Invalid SQL data type <-25>

 

)

 

I googled and found this on an IBM help page: 

 

Cause: "ODBC libraries for Oracle do not support the SQL_C_SBIGINT ODBC type, which corresponds to the int64 SPL type."

 

Solution: "There is no workaround. If you use an Oracle database, do not use the SPL int64 type in your applications."

 

How can I change _not_ to use SPL int64 data type? Or is there another way around this?

 

Need Help

4 Replies

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    We know about this issue and working on this. Can you use our own Oracle connector instead of ODBC?

    • chefe's avatar
      chefe
      Helper II
      10 years ago

      Hi. thank you for taking the time and respond!

       

      I can connect fine when I choose to connect using "Get Data > Databases > Oracle Databases", but this does not work with

      DirectQuery... then I am getting an Oracle Client Error Message (see this topic where I describe it).

       

      My work machine does not have a driver "Microsoft ODBC Driver for Oracle" installed however... It seems to me we are using an original oracle something along the lines of "oracle 11g home1". I am trying to use ODBC as a workaround. My primary goal ist connect to Oracle using DirectQuery.

      • wonga's avatar
        wonga
        Continued Contributor
        10 years ago

        Why are you unable to connect to Oracle DB through DirectQuery? Are you performing operations on the data that forces you to import instead?