10 Replies Latest reply on Sep 8, 2009 3:05 PM by user478475

    Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc

    k3pa
      We have Oracle 10.2.0.4 in RHEL 4 (x86_64). We have installed Oracle Gateway (11.1.0.6.0) in a different ORACLE_HOME to connect to several databases through ODBC.

      We have succesfully installed and configured an ODBC connection to a SQL Server through Oracle Gateway with UnixODBC+FreeTDS. The dblinks works fine.

      We are now trying to set up another connection to an Informix server (32 bits), but we get this error:

      -----
      SQL> select * from tabla1@test_informix;
      select * from tabla1@test_informix
      *
      ERROR at line 1:
      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [Informix][Informix ODBC Driver]Driver not capable.
      ORA-02063: preceding 2 lines from TEST_INFORMIX
      -----

      However, we are able to connect with isql
      -----
      oracle@host $ isql -v test_informix
      ---------------------------------------
      | Connected! |
      | |
      | sql-statement |
      | help [tablename] |
      | quit |
      | |
      ---------------------------------------
      SQL> select * from tabla1;
      ------------
      | cola |
      ------------
      | 10 |
      | 11 |
      ------------
      SQLRowCount returns -1
      2 rows fetched

      -----


      We have configured the CSDK Informix 3.50.FC4DE for Linux with UnixODBC like this:

      -----
      odbcinst.ini
      -----
      [Informix]
      Description=Informix ODBC Driver
      Driver=/usr/share/informix/lib/cli/libifcli.so
      APILevel=1
      ConnectFunctions=YYY
      DriverODBCVer=03.51
      FileUsage=0
      SQLLevel=1
      smProcessPerConnect=Y
      -----

      -----
      Oracle HS log
      -----
      Oracle Corporation --- MONDAY AUG 10 2009 12:40:00.373


      Heterogeneous Agent Release
      11.1.0.6.0




      Oracle Corporation --- MONDAY AUG 10 2009 12:40:00.372

      Version 11.1.0.6.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
      setting HS_FDS_RECOVERY_PWD to default value
      setting HS_FDS_TRANSACTION_LOG to default of "HS_TRANSACTION_LOG"
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      setting HS_FDS_TIMESTAMP_AS_DATE to default of "TRUE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      setting HS_FDS_FETCH_ROWS to default of "100"
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
      setting HS_FDS_MAP_NCHAR to default of "TRUE"
      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
      setting HS_FDS_QUERY_DRIVER to default of "TRUE"
      setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics"
      Exiting hgosdip, rc=0
      ORACLE_SID is "test_informix"
      Product-Info:
      Port Rls/Upd:6/0 PrdStat:0
      Agent:Oracle Database Gateway for ODBC
      Facility:hsa
      Class:ODBC, ClassVsn:11.1.0.6.0_0006, Instance:test_informix
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=31
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=31
      HOCXU_SEM_VER=102000
      Entered hgolofn at 2009/08/10-12:40:00
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libodbc.so"
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLAllocHandle
      symbol_peflctx=0x9893b70d
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLBindCol
      symbol_peflctx=0x9893b873
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLBindParameter
      symbol_peflctx=0x9893c2e4
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLCancel
      symbol_peflctx=0x9893dc84
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeParam
      symbol_peflctx=0x98948f10
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLDisconnect
      symbol_peflctx=0x989495c8
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLEndTran
      symbol_peflctx=0x9894c4d4
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLExecute
      symbol_peflctx=0x9894e17c
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLFetch
      symbol_peflctx=0x9894ed04
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLFreeHandle
      symbol_peflctx=0x98950fc9
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLFreeStmt
      symbol_peflctx=0x98950fec
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetData
      symbol_peflctx=0x989531dc
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetEnvAttr
      symbol_peflctx=0x98956fa8
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetFunctions
      symbol_peflctx=0x989573c4
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLMoreResults
      symbol_peflctx=0x98959b28
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLNumResultCols
      symbol_peflctx=0x9895aad8
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLParamData
      symbol_peflctx=0x9895aedc
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLPutData
      symbol_peflctx=0x9895d908
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLRowCount
      symbol_peflctx=0x9895de78
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLSetEnvAttr
      symbol_peflctx=0x98960458
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescRec
      symbol_peflctx=0x98960230
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLColAttribute
      symbol_peflctx=0x9893e4ec
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLColumns
      symbol_peflctx=0x989406e4
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLConnect
      symbol_peflctx=0x98946014
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLDescribeCol
      symbol_peflctx=0x989484f0
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLDriverConnect
      symbol_peflctx=0x9894a337
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLExecDirect
      symbol_peflctx=0x9894d9e2
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLForeignKeys
      symbol_peflctx=0x9894fbdc
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetConnectAttr
      symbol_peflctx=0x989514ab
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagField
      symbol_peflctx=0x989557f3
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetDiagRec
      symbol_peflctx=0x989566e5
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetInfo
      symbol_peflctx=0x98958083
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetStmtAttr
      symbol_peflctx=0x989583e3
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLGetTypeInfo
      symbol_peflctx=0x98959548
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLPrepare
      symbol_peflctx=0x9895b9c6
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLPrimaryKeys
      symbol_peflctx=0x9895c13e
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLProcedureColumns
      symbol_peflctx=0x9895c938
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLProcedures
      symbol_peflctx=0x9895d19a
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLSetConnectAttr
      symbol_peflctx=0x9895e1fc
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLSetStmtAttr
      symbol_peflctx=0x989624a8
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLSetDescField
      symbol_peflctx=0x9895fe5a
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLStatistics
      symbol_peflctx=0x98964ed6
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Entered hgolofns at 2009/08/10-12:40:00
      libname=/usr/local/lib/libodbc.so, funcname=SQLTables
      symbol_peflctx=0x98966014
      hoaerr:0
      Exiting hgolofns at 2009/08/10-12:40:00
      Exiting hgolofn, rc=0 at 2009/08/10-12:40:00
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
      Exiting hgoinit, rc=0 at 2009/08/10-12:40:00
      Entered hgolgon at 2009/08/10-12:40:00
      reco:0, name:informix, tflag:0
      Entered hgosuec at 2009/08/10-12:40:00
      Exiting hgosuec, rc=0 at 2009/08/10-12:40:00
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned ""HS_TRANSACTION_LOG""
      HOSGIP for "HS_FDS_TIMESTAMP_AS_DATE" returned "TRUE"
      HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULT_SET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using informix as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2009/08/10-12:40:00
      HS_FDS_CONNECT_INFO = "test_informix"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2009/08/10-12:40:00
      dsn:test_informix, name:informix
      optn:
      ##>Connect Parameters (len=42)<##
      ## DSN=test_informix;
      #! UID=informix;
      #! PWD=*
      Exiting hgogenconstr, rc=0 at 2009/08/10-12:40:00
      DriverName:iclis09b.so, DriverVer: 3.50.0000 3.50.U
      DBMS Name:Informix, DBMS Version:07.31.0000 UD5
      Exiting hgocont, rc=0 at 2009/08/10-12:40:00
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 18 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2009/08/10-12:40:00
      Entered hgoulcp at 2009/08/10-12:40:00
      Entered hgowlst at 2009/08/10-12:40:00
      Exiting hgowlst, rc=0 at 2009/08/10-12:40:00
      SQLGetInfo returns for SQL_IDENTIFIER_QUOTE_CHAR
      SQLGetInfo returns N for SQL_COLUMN_ALIAS
      Exiting hgoulcp, rc=0 at 2009/08/10-12:40:00
      Entered hgouldt at 2009/08/10-12:40:00
      Exiting hgouldt, rc=0 at 2009/08/10-12:40:00
      Entered hgobegn at 2009/08/10-12:40:00
      tflag:0 , initial:1
      hoi:0xbfffe728, ttid (len 24) is ...
      00: 54534554 3135352E 36616133 31312E37 [TEST.5513aa67.11]
      10: 2E35332E 38303131 [.35.1108]
      tbid (len 10) is ...
      0: 0023000B 00000454 0104 [..#.T.....]
      Entered hgopoer at 2009/08/10-12:40:00
      hgopoer, line 159: got native error -11092 and sqlstate HYC00; message follows...
      [Informix][Informix ODBC Driver]Driver not capable.
      Exiting hgopoer, rc=0 at 2009/08/10-12:40:00
      hgobegn, line 176: calling SQLEndTran got sqlstate HYC00
      Exiting hgobegn, rc=28500 at 2009/08/10-12:40:00 with error ptr FILE:hgobegn.c LINE:176 FUNCTION:hgobegn() ID:SqlEndTran call
      Entered hgolgof at 2009/08/10-12:40:51
      tflag:1
      Exiting hgolgof, rc=0 at 2009/08/10-12:40:51
      Entered hgoexit at 2009/08/10-12:40:51
      Exiting hgoexit, rc=0 at 2009/08/10-12:40:51
      -----

      Any ideas?

      Thanks!
        • 1. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
          Kgronau-Oracle
          the error you get seems to be an issue with the ODBC driver you use:
          hgopoer, line 159: got native error -11092 and sqlstate HYC00; message follows...
          InformixInformix ODBC DriverDriver not capable.
          Exiting hgopoer, rc=0 at 2009/08/10-12:40:00
          hgobegn, line 176: calling SQLEndTran got sqlstate HYC00
          Exiting hgobegn, rc=28500 at 2009/08/10-12:40:00 with error ptr FILE:hgobegn.c LINE:176 FUNCTION:hgobegn() ID:SqlEndTran call


          Enable ODBC tracing to see which function fails and post the log. You can also download the DataDirect Trial ODBC driver to see if it works with this driver.
          • 2. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
            k3pa
            This is the ODBC trace when we run the previous select statement in Oracle.

            [ODBC][31779][1249981080.347292][__handles.c][450]
            Exit:[SQL_SUCCESS]
            Environment = 0x6063b0
            [ODBC][31779][1249981080.347360][SQLSetEnvAttr.c][182]
            Entry:
            Environment = 0x6063b0
            Attribute = SQL_ATTR_ODBC_VERSION
            Value = 0x3
            StrLen = -6
            [ODBC][31779][1249981080.347393][SQLSetEnvAttr.c][349]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.347658][SQLAllocHandle.c][364]
            Entry:
            Handle Type = 2
            Input Handle = 0x6063b0
            [ODBC][31779][1249981080.347687][SQLAllocHandle.c][482]
            Exit:[SQL_SUCCESS]
            Output Handle = 0x608dc0
            [ODBC][31779][1249981080.347722][SQLSetConnectAttr.c][321]
            Entry:
            Connection = 0x608dc0
            Attribute = SQL_ATTR_AUTOCOMMIT
            Value = (nil)
            StrLen = -5
            [ODBC][31779][1249981080.347751][SQLSetConnectAttr.c][504]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.348088][SQLDriverConnect.c][687]
            Entry:
            Connection = 0x608dc0
            Window Hdl = (nil)
            Str In = [DSN=test_informix;UID=informix;PWD=*******][length = 42]
            Str Out = 0x61b3c8
            Str Out Max = 1024
            Str Out Ptr = 0x7fbfffe2e4
            Completion = 0
            UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

            DIAG [01S02] [Informix][Informix ODBC Driver]Option value changed.

            [ODBC][31779][1249981080.497863][SQLDriverConnect.c][1496]
            Exit:[SQL_SUCCESS_WITH_INFO]
            Connection Out [[][length = 0 (SQL_NTS)]]
            [ODBC][31779][1249981080.497910][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_DRIVER_NAME (6)
            Info Value = 0x7fbfffdfc0
            Buffer Length = 512
            StrLen = 0x7fbfffe2e8
            [ODBC][31779][1249981080.497939][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.497980][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_DRIVER_VER (7)
            Info Value = 0x7fbfffdfc0
            Buffer Length = 512
            StrLen = 0x7fbfffe2e8
            [ODBC][31779][1249981080.498007][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.498066][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_DBMS_NAME (17)
            Info Value = 0x7fbfffdfc0
            Buffer Length = 512
            StrLen = 0x7fbfffe2e8
            [ODBC][31779][1249981080.498094][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.498125][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_DBMS_VER (18)
            Info Value = 0x7fbfffdfc0
            Buffer Length = 512
            StrLen = 0x7fbfffe2e8
            [ODBC][31779][1249981080.498642][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.498753][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_CATALOG_NAME (10003)
            Info Value = 0x7fbfffe330
            Buffer Length = 512
            StrLen = 0x7fbfffe5c4
            [ODBC][31779][1249981080.498782][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.498839][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_MAX_CATALOG_NAME_LEN (34)
            Info Value = 0x7fbfffe5c8
            Buffer Length = 2
            StrLen = (nil)
            [ODBC][31779][1249981080.498869][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.498914][SQLGetConnectAttr.c][285]
            Entry:
            Connection = 0x608dc0
            Attribute = SQL_ATTR_CURRENT_CATALOG
            Value = 0x61b7b0
            Buffer Length = 18
            StrLen = 0x605830
            [ODBC][31779][1249981080.498965][SQLGetConnectAttr.c][757]
            Exit:[SQL_SUCCESS_WITH_INFO]
            DIAG [01004] [Informix][Informix ODBC Driver]Data truncated.

            [ODBC][31779][1249981080.503699][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_IDENTIFIER_QUOTE_CHAR (29)
            Info Value = 0x7fbfffe220
            Buffer Length = 512
            StrLen = 0x7fbfffe6c4
            [ODBC][31779][1249981080.503763][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.503805][SQLGetInfo.c][546]
            Entry:
            Connection = 0x608dc0
            Info Type = SQL_COLUMN_ALIAS (87)
            Info Value = 0x7fbfffe220
            Buffer Length = 512
            StrLen = 0x7fbfffe6c4
            [ODBC][31779][1249981080.503832][SQLGetInfo.c][608]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.503873][SQLGetFunctions.c][147]
            Entry:
            Connection = 0x608dc0
            Id = 999
            Supported = 0x7fbfffe420
            [ODBC][31779][1249981080.503906][SQLGetFunctions.c][182]
            Exit:[SQL_SUCCESS]
            Supported = 0x7fbfffe420 -> -2
            [ODBC][31779][1249981080.503937][SQLAllocHandle.c][529]
            Entry:
            Handle Type = 3
            Input Handle = 0x608dc0
            [ODBC][31779][1249981080.504010][SQLAllocHandle.c][1064]
            Exit:[SQL_SUCCESS]
            Output Handle = 0x686e00
            [ODBC][31779][1249981080.504050][SQLBindCol.c][225]
            Entry:
            Statement = 0x686e00
            Column Number = 1
            Target Type = 1 SQL_CHAR
            Target Value = 0x7fbfffe1a8
            Buffer Length = 120
            StrLen Or Ind = 0x7fbfffe668
            [ODBC][31779][1249981080.504087][SQLBindCol.c][329]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504116][SQLBindCol.c][225]
            Entry:
            Statement = 0x686e00
            Column Number = 3
            Target Type = -16 SQL_C_SLONG
            Target Value = 0x7fbfffe6c0
            Buffer Length = 0
            StrLen Or Ind = 0x7fbfffe670
            [ODBC][31779][1249981080.504143][SQLBindCol.c][329]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504172][SQLBindCol.c][225]
            Entry:
            Statement = 0x686e00
            Column Number = 10
            Target Type = -15 SQL_C_SSHORT
            Target Value = 0x7fbfffe6c8
            Buffer Length = 0
            StrLen Or Ind = 0x7fbfffe670
            [ODBC][31779][1249981080.504230][SQLBindCol.c][329]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504261][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_VARCHAR
            [ODBC][31779][1249981080.504321][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504351][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504436][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504464][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504496][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.504526][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.504556][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504584][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_INTEGER
            [ODBC][31779][1249981080.504615][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504641][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504671][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504697][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504725][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504751][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504779][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.504805][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.504833][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504862][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_INTEGER
            [ODBC][31779][1249981080.504893][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504921][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.504966][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.504994][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505022][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505048][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505075][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505103][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_SMALLINT
            [ODBC][31779][1249981080.505133][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505159][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505204][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505230][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505257][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.505283][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505311][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505338][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_SMALLINT
            [ODBC][31779][1249981080.505368][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505396][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505425][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505452][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505480][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505509][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_VARBINARY
            [ODBC][31779][1249981080.505542][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505568][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505596][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.505623][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505650][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505677][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_BIGINT
            [ODBC][31779][1249981080.505708][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505733][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505762][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.505789][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505816][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505845][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_TINYINT
            [ODBC][31779][1249981080.505876][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.505902][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.505930][SQLFetch.c][340]
            Exit:[SQL_NO_DATA]
            [ODBC][31779][1249981080.505956][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.505983][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506010][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_LONGVARCHAR
            [ODBC][31779][1249981080.506041][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506067][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.506096][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506122][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.506149][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506176][SQLGetTypeInfo.c][164]
            Entry:
            Statement = 0x686e00
            Data Type = SQL_LONGVARBINARY
            [ODBC][31779][1249981080.506224][SQLGetTypeInfo.c][314]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506251][SQLFetch.c][158]
            Entry:
            Statement = 0x686e00
            [ODBC][31779][1249981080.506280][SQLFetch.c][340]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506306][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 0
            [ODBC][31779][1249981080.506333][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.506360][SQLFreeStmt.c][140]
            Entry:
            Statement = 0x686e00
            Option = 2
            [ODBC][31779][1249981080.506387][SQLFreeStmt.c][246]
            Exit:[SQL_SUCCESS]
            [ODBC][31779][1249981080.511893][SQLEndTran.c][318]
            Entry:
            Connection = 0x608dc0
            Completion Type = 0
            [ODBC][31779][1249981080.511932][SQLEndTran.c][504]
            Exit:[SQL_ERROR]
            DIAG [HYC00] [Informix][Informix ODBC Driver]Driver not capable.

            [ODBC][31779][1249981080.512046][SQLGetDiagRec.c][661]
            Entry:
            Connection = 0x608dc0
            Rec Number = 1
            SQLState = 0x7fbfffe608
            Native = 0x7fbfffe680
            Message Text = 0x7fbfffe3f0
            Buffer Length = 510
            Text Len Ptr = 0x7fbfffe684
            [ODBC][31779][1249981080.512089][SQLGetDiagRec.c][698]
            Exit:[SQL_SUCCESS]
            SQLState = HYC00
            Native = 0x7fbfffe680 -> -11092
            Message Text = [[Informix][Informix ODBC Driver]Driver not capable.]
            [ODBC][31779][1249981080.512121][SQLGetDiagRec.c][661]
            Entry:
            Connection = 0x608dc0
            Rec Number = 2
            SQLState = 0x7fbfffe608
            Native = 0x7fbfffe680
            Message Text = 0x7fbfffe3f0
            Buffer Length = 510
            Text Len Ptr = 0x7fbfffe684
            [ODBC][31779][1249981080.512150][SQLGetDiagRec.c][698]
            Exit:[SQL_NO_DATA]
            • 3. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
              Kgronau-Oracle
              The function that fails is:
              ODBC][31779][1249981080.511932][SQLEndTran.c][504]
              Exit:[SQL_ERROR]
              DIAG [HYC00] [Informix][Informix ODBC Driver]Driver not capable.

              Is you Informix database running in nolog or in logging mode?
              • 4. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                k3pa
                It's in no logging mode.

                I've got a few questions about Data direct drivers for ODBC. Will we need to use UnixODBC as the driver manager, or is it included in the Datadirect software? As we are using Oracle 10.2.0.4 in a x86_64 server, we need to use the ODBC 64 bits or the regular 32 bits version?

                Thanks! I really appreciate your help.
                • 5. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                  k3pa
                  I have tried to setup the Datadirect Connect64 ODBC for Informix and it reports the Informix version is not supported. It's an Informix 7.31.UD5. It's getting really tricky to setup the odbc connection in any way.

                  -----
                  Trace file
                  -----

                  [root@ad0cedas01 tmp]# more odbctrace.out
                  ppid=000003b4,pid=00000000 ENTER SQLSetEnvAttr
                  SQLHENV 0x0052C5C0
                  SQLINTEGER 200
                  SQLPOINTER 0x00000002
                  SQLINTEGER 0

                  ppid=000003b4,pid=00000000 EXIT SQLSetEnvAttr
                  SQLHENV 0x0052C5C0
                  SQLINTEGER 200
                  SQLPOINTER 0x00000002
                  SQLINTEGER 0 with return code 0 (SQL_SUCCESS)

                  ppid=000003b4,pid=00000000 ENTER SQLGetEnvAttr
                  SQLHENV 0x0052C5C0
                  SQLINTEGER 200
                  SQLPOINTER 0x7FBFFFDA68
                  SQLINTEGER 0
                  SQLINTEGER * 0x2A9890528E

                  ppid=000003b4,pid=00000000 EXIT SQLGetEnvAttr
                  SQLHENV 0x0052C5C0
                  SQLINTEGER 200
                  SQLPOINTER 0x7FBFFFDA68
                  SQLINTEGER 0
                  SQLINTEGER * 0x2A9890529C with return code 0 (SQL_SUCCESS)

                  ppid=000003b4,pid=00000000 ENTER SQLAllocHandle
                  SQLSMALLINT 2
                  SQLHANDLE 0x0052c5c0
                  SQLHANDLE * 0x0050d420

                  ppid=000003b4,pid=00000000 EXIT SQLAllocHandle
                  SQLSMALLINT 2
                  SQLHANDLE 0x0052c5c0
                  SQLHANDLE * 0x0050d420 with return code 0 (SQL_SUCCESS)

                  ppid=000003b4,pid=00000000 ENTER SQLConnectW
                  SQLHDBC 0x00533E00
                  SQLWCHAR t
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3

                  ppid=000003b4,pid=00000000 EXIT SQLConnectW
                  SQLHDBC 0x00533E00
                  SQLWCHAR t
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3 with return code -1 (SQL_ERROR)

                  ppid=000003b4,pid=00000000 ENTER SQLGetDiagRecW
                  ,SQLSMALLINT 2
                  SQLHANDLE 0x00533E00
                  SQLSMALLINT 1
                  SQLWCHAR * ýÿ
                  SQLINTEGER * 0x7FBFFFEC1C
                  SQLWCHAR * SQLConnectW
                  SQLHDBC 0x00533E00
                  SQLWCHAR t
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3
                  SQLWCHAR * (null)
                  SQLSMALLINT -3
                  SQLSMALLINT 2056
                  SQLSMALLINT * 0x7FBFFFEC1A

                  ppid=000003b4,pid=00000000 EXIT SQLGetDiagRecW
                  ,SQLSMALLINT 2
                  SQLHANDLE 0x00533E00
                  SQLSMALLINT 1
                  SQLWCHAR * S
                  SQLINTEGER * 0x7FBFFFEC1C
                  SQLWCHAR * [
                  SQLSMALLINT 2056
                  SQLSMALLINT * 0x7FBFFFEC1A with return code 0 (SQL_SUCCESS)

                  ppid=000003b4,pid=00000000 ENTER SQLGetDiagRecW
                  ,SQLSMALLINT 2
                  SQLHANDLE 0x00533E00
                  SQLSMALLINT 2
                  SQLWCHAR * S
                  SQLINTEGER * 0x7FBFFFEC1C
                  SQLWCHAR *
                  SQLSMALLINT 2056
                  SQLSMALLINT * 0x7FBFFFEC1A

                  ppid=000003b4,pid=00000000 EXIT SQLGetDiagRecW
                  ,SQLSMALLINT 2
                  SQLHANDLE 0x00533E00
                  SQLSMALLINT 2
                  SQLWCHAR * S
                  SQLINTEGER * 0x7FBFFFEC1C
                  SQLWCHAR *
                  SQLSMALLINT 2056
                  SQLSMALLINT * 0x7FBFFFEC1A with return code 100 (SQL_NO_DATA_FOUND)

                  ppid=000003b4,pid=00000000 ENTER SQLFreeHandle
                  SQLSMALLINT 2
                  SQLHANDLE 0x00533e00

                  ppid=000003b4,pid=00000000 EXIT SQLFreeHandle
                  SQLSMALLINT 2
                  SQLHANDLE 0x00000000 with return code 0 (SQL_SUCCESS)

                  ppid=000003b4,pid=00000000 ENTER SQLFreeHandle
                  SQLSMALLINT 1
                  SQLHANDLE 0x0052c5c0

                  ppid=000003b4,pid=00000000 EXIT SQLFreeHandle
                  SQLSMALLINT 1
                  SQLHANDLE 0x00000000 with return code 0 (SQL_SUCCESS)


                  ppid=30743:pid= 5d3:9670d440 ENTER SQLAllocConnect
                  HENV 0x00596d30
                  HDBC * 0xbffff828

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
                  HENV 0x00596d30
                  HDBC * 0xbffff828 ( 0x00597c90)

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLConnect
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLConnect with return code -1 (SQL_ERROR)
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 0 (SQL_SUCCESS)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 [  5] "S1000"
                  SDWORD * 0xbfffeedc (0)
                  UCHAR * 0xbfffeee0 [      84] "[DataDirect][ODBC Informix Wire Protocol driver]Unsupported Informix
                  Server version."
                  SWORD 511
                  SWORD * 0xbfffeeda (84)

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLConnect
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLConnect with return code -1 (SQL_ERROR)
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 0 (SQL_SUCCESS)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 [  5] "S1000"
                  SDWORD * 0xbfffeedc (0)
                  UCHAR * 0xbfffeee0 [      84] "[DataDirect][ODBC Informix Wire Protocol driver]Unsupported Informix
                  Server version."
                  SWORD 511
                  SWORD * 0xbfffeeda (84)

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLConnect
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLConnect with return code -1 (SQL_ERROR)
                  HDBC 0x00597c90
                  UCHAR * 0xbffff7b0 [4294967293] "Informix"
                  SWORD -3
                  UCHAR * 0xbffff7f0 [4294967293] "informix"
                  SWORD -3
                  UCHAR * 0x957ab6d0 [4294967293] "******"
                  SWORD -3

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 0 (SQL_SUCCESS)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 [  5] "S1000"
                  SDWORD * 0xbfffeedc (0)
                  UCHAR * 0xbfffeee0 [      84] "[DataDirect][ODBC Informix Wire Protocol driver]Unsupported Informix
                  Server version."
                  SWORD 511
                  SWORD * 0xbfffeeda (84)

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 ENTER SQLError
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda

                  ppid=30743:pid= 5d3:9670d440 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
                  HENV 0x00596d30
                  HDBC 0x00597c90
                  HSTMT 0x00000000
                  UCHAR * 0xbffff0e0 (NYI)
                  SDWORD * 0xbfffeedc
                  UCHAR * 0xbfffeee0
                  SWORD 511
                  SWORD * 0xbfffeeda
                  • 6. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                    Kgronau-Oracle
                    Datadirect offered in the past a suitable driver for Informix 7.3. Maybe you should get in touch with their support about a suitable driver.

                    Now to the Transaction problem:
                    DG4ODBC is commonly opening a transaction as it allows to commit or rollback an update/insert/delete. When the Informix database is in nolog mode the transaction open fails. You might enable logging on the Informix database, but this might cause performance decrease on the Informix db.
                    Another approach is a patch generated for DG4IFMX (7417128) which can be used for DG4ODBC as well after relinking the client and DG4ODBC afterwards:
                    genagtsh $ORACLE_HOME/lib/libagtsh.so 1.0
                    make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk idg4odbc

                    Check out Metalink if it is available for your platform and set the parameter as described in the readme.
                    It was working in the past with Datadirect ODBC drivers. Unfortunately it failed for some Informix drivers.
                    Instead of purchasing the Datadirect ODBC driver you might also think about the DG4IFMX usage. It is certified with Informix 7.31.
                    • 7. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                      k3pa
                      I see. I've tried to setup the connection to an Informix server with logging enabled. I created a dblink using dg4odbc and when I issue a select, the statement is translated but not accepted by the server. It seems like there is a problem with the quotes within the select. Is this a matter of Informix, Oracle or the ODBC Drivers?

                      -----
                      Log
                      -----
                      ...
                      ...
                      [ODBC][2124][1249991670.526677][SQLFreeStmt.c][140]
                      Entry:
                      Statement = 0x688a70
                      Option = 2
                      [ODBC][2124][1249991670.526704][SQLFreeStmt.c][246]
                      Exit:[SQL_SUCCESS]
                      [ODBC][2124][1249991670.527614][SQLAllocHandle.c][529]
                      Entry:
                      Handle Type = 3
                      Input Handle = 0x608ba0
                      [ODBC][2124][1249991670.527664][SQLAllocHandle.c][1064]
                      Exit:[SQL_SUCCESS]
                      Output Handle = 0x698b50
                      [ODBC][2124][1249991670.527700][SQLPrepare.c][192]
                      Entry:
                      Statement = 0x698b50
                      SQL = [SELECT A1."cod_agent",A1."desc_agent" FROM "AGENTES" A1][length = 55]
                      [ODBC][2124][1249991670.529047][SQLPrepare.c][367]
                      Exit:[SQL_ERROR]
                      DIAG [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred.

                      [ODBC][2124][1249991670.529208][SQLGetDiagRec.c][739]
                      Entry:
                      Statement = 0x698b50
                      Rec Number = 1
                      SQLState = 0x7fbfffd1f8
                      Native = 0x7fbfffd270
                      Message Text = 0x7fbfffcfe0
                      Buffer Length = 510
                      Text Len Ptr = 0x7fbfffd274
                      [ODBC][2124][1249991670.529254][SQLGetDiagRec.c][776]
                      Exit:[SQL_SUCCESS]
                      SQLState = 42000
                      Native = 0x7fbfffd270 -> -201
                      Message Text = [[Informix][Informix ODBC Driver][Informix]A syntax error has occurred.]
                      [ODBC][2124][1249991670.529286][SQLGetDiagRec.c][739]
                      Entry:
                      Statement = 0x698b50
                      Rec Number = 2
                      SQLState = 0x7fbfffd1f8
                      Native = 0x7fbfffd270
                      Message Text = 0x7fbfffcfe0
                      Buffer Length = 510
                      Text Len Ptr = 0x7fbfffd274
                      [ODBC][2124][1249991670.529315][SQLGetDiagRec.c][776]
                      Exit:[SQL_NO_DATA]
                      • 8. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                        Kgronau-Oracle
                        The Informix delimident is not set to "y".
                        http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls1077.htm

                        You might add to the dg4odbc initalisation file:
                        set DELIMIDENT=y
                        1 person found this helpful
                        • 9. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                          k3pa
                          That's it! Thank you very much.

                          The logging mode & DELIMIDENT parameter were the key.

                          Now I have to face why I don't get the whole table when I run a selects but for sure it's a different problem.

                          Thanks again.
                          • 10. Re: Error connecting from Oracle 10.2.0.4 to Informix with dg4odbc
                            user478475
                            kgronau,

                            Do you know of a way to change the drivers so they do not require logging on the informix side. I am attempting to set up the Oracle Informix gateway 11.0.7, I have installed and configured everthing and now I am receiving the following error:

                            ORA-28500:
                            connection from ORACLE to a non-Oracle system returned this message:
                            [Oracle][ODBC Informix Wire Protocol driver][Informix]
                            Transaction not available. ORA-02063: preceding 2 lines from CMS_NET