1 Reply Latest reply: Feb 18, 2008 8:11 AM by MMEGE-Oracle RSS

    RDB ODBC

    user607387
      Hallo,

      I have a problem wirth the connection between oracle and oracle-rdb via ODBC.
      I use Oracle 10g / HSODBC / RDB ODBC 3.1 and it runs fine.
      I want migrate to Oracle 11g / DG4ODBC / RDB ODBC 3.2 and it doesn't work:
      Seems RDB ODBC driver does not handle SQLColumnsW correctly.
      It returns HYC00 Optional feature not implemented.

      Can you help?

      Error:
      ====
      ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Oracle][ODBC]RDB%SQL-F-SYNTAX_ERR, Syntax error
      ORA-02063: preceding 2 lines from ...

      ODBC Tracing:
      ===========
      DG4ODBChssidmp1 e48-1758 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
      HSTMT 01D627B8
      UWORD 16
      SWORD -16 <SQL_C_SLONG>
      PTR 0x0012EF88
      SQLLEN 0
      SQLLEN * 0x0012EF84 (0)

      DG4ODBChssidmp1 e48-1758 ENTER SQLColumnsW
      HSTMT 01D627B8
      WCHAR * 0x00000000
      SWORD 0
      WCHAR * 0x01D62770 [ 7] "userid"
      SWORD 7
      WCHAR * 0x01D62050 [ 6] "TABLE"
      SWORD 6
      WCHAR * 0x00000000
      SWORD 0

      DG4ODBChssidmp1 e48-1758 EXIT SQLColumnsW with return code -1 (SQL_ERROR)
      HSTMT 01D627B8
      WCHAR * 0x00000000
      SWORD 0
      WCHAR * 0x01D62770 [ 7] "userid"
      SWORD 7
      WCHAR * 0x01D62050 [ 6] "TABLE"
      SWORD 6
      WCHAR * 0x00000000
      SWORD 0

      DIAG [HYC00] [Oracle][ODBC]Optional feature not implemented. (0)

      DG4ODBChssidmp1 e48-1758 ENTER SQLFreeStmt
      HSTMT 01D627B8
      UWORD 2 <SQL_UNBIND>

      DG4ODBChssidmp1 e48-1758 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
      HSTMT 01D627B8
      UWORD 2 <SQL_UNBIND>

      DG4ODBChssidmp1 e48-1758 ENTER SQLAllocHandle
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 01D61CC0
      SQLHANDLE * 020872AC

      DG4ODBChssidmp1 e48-1758 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
      SQLSMALLINT 3 <SQL_HANDLE_STMT>
      SQLHANDLE 01D61CC0
      SQLHANDLE * 0x020872AC ( 0x01d62090)

      DG4ODBChssidmp1 e48-1758 ENTER SQLPrepare
      HSTMT 01D62090
      UCHAR * 0x02088048 [ 22] "SELECT * FROM "TABLE""
      SDWORD 22

      DG4ODBChssidmp1 e48-1758 EXIT SQLPrepare with return code -1 (SQL_ERROR)
      HSTMT 01D62090
      UCHAR * 0x02088048 [ 22] "SELECT * FROM "TABLE""
      SDWORD 22

      DIAG [HY000] [Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error (-1)

      DG4ODBChssidmp1 e48-1758 ENTER SQLGetDiagRecW
      SQLSMALLINT 3
      SQLHANDLE 01D62090
      SQLSMALLINT 1
      SQLWCHAR * 0x0012D9D0 (NYI)
      SQLINTEGER * 0x0012DC24
      SQLWCHAR * 0x01D63048 (NYI)
      SQLSMALLINT 510
      SQLSMALLINT * 0x0012DC28

      DG4ODBChssidmp1 e48-1758 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
      SQLSMALLINT 3
      SQLHANDLE 01D62090
      SQLSMALLINT 1
      SQLWCHAR * 0x0012D9D0 (NYI)
      SQLINTEGER * 0x0012DC24 (-1)
      SQLWCHAR * 0x01D63048 (NYI)
      SQLSMALLINT 510
      SQLSMALLINT * 0x0012DC28 (50)