11 Replies Latest reply: Oct 15, 2012 12:00 AM by Kgronau-Oracle RSS

    Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails

    AlesGolob
      I'm trying to connect to a Firebird 2.0.7 server using the free [Firebird ODBC driver|http://www.firebirdsql.org/en/odbc-driver/] with unixODBC 2.3.0 and dg4ODBC 11.2.0.3.0 - 64bit but the connection fails with an "ORA-28511: lost RPC connection to heterogeneous remote agent using" error.

      odbc.ini
      [vasco]
      Driver=Firebird
      Dbname=fbspan.example.com:/opt/firebird/vasco.fdb
      User=sysdba
      Password=password
      ReadOnly=No
      NoWait=No
      initdg4odbc.ora
      #
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO = vasco
      HS_FDS_CONNECT_STRING = "CHARSET=ISO8859_2"
      HS_FDS_TRACE_LEVEL = 255
      HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
      
      #
      # ODBC specific environment variables
      #
      set ODBCINI=/etc/unixODBC/odbc.ini
      
      HS_NLS_NCHAR = UCS2
      HS_LANGUAGE = SLOVENIAN_SLOVENIA.EE8ISO8859P2
      Executing a select returns this error:
      SQL> SELECT KRATICA FROM DRZAVA@vasco;
      SELECT KRATICA FROM DRZAVA@vasco
                                 *
      ERROR at line 1:
      ORA-28511: lost RPC connection to heterogeneous remote agent using
      SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
      SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraeval.example.com)(PO
      RT=1522)))(CONNECT_DATA=(SID=dg4odbc)))
      ORA-02063: preceding line from VASCO
      Process ID: 5130
      Session ID: 140 Serial number: 1554
      dg4odbc trace file level 255:
      Oracle Corporation --- WEDNESDAY OCT 10 2012 11:45:04.615
      
      
      Heterogeneous Agent Release 
      11.2.0.3.0 
      
      
      
      
      Oracle Corporation --- WEDNESDAY OCT 10 2012 11:45:04.614
      
          Version 11.2.0.3.0
      
      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"
      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_IDLE_TIMEOUT to default of 0
       setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
       HOSGIP returned value of "UCS2" for HS_NLS_NCHAR
       setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
       setting HS_FDS_DATE_MAPPING to default of "DATE"
       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_RSET_RETURN_ROWCOUNT to default of "FALSE"
       setting HS_FDS_PROC_IS_FUNC 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_FDS_QUOTE_IDENTIFIER to default of "TRUE"
       setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
       setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
       setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
       setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
       setting HS_FDS_DELAYED_OPEN to default of "TRUE"
       setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
       ORACLE_SID is "dg4odbc"
       Product-Info:
        Port Rls/Upd:3/0 PrdStat:0
        Agent:Oracle Database Gateway for ODBC
        Facility:hsa
        Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:dg4odbc
      Exiting hgogprd, rc=0
      hostmstr:          0:      HOA After hoagprd
      hostmstr:          0:      HOA Before hoainit
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=32
      HOCXU_DRV_NCHAR=1000
      HOCXU_DB_CSET=873
      HS_LANGUAGE is SLOVENIAN_SLOVENIA.EE8ISO8859P2
      LANG=en_US.UTF-8
      HOCXU_SEM_VER=112000
      Entered hgolofn at 2012/10/10-11:45:04
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so"
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLAllocHandle
       symbol_peflctx=0x83e20380
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLBindCol
       symbol_peflctx=0x83e20500
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLBindParameter
       symbol_peflctx=0x83e20dc0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLCancel
       symbol_peflctx=0x83e22150
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLDescribeParam
       symbol_peflctx=0x83e2a6c0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLDisconnect
       symbol_peflctx=0x83e2ab80
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLEndTran
       symbol_peflctx=0x83e2d640
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLExecute
       symbol_peflctx=0x83e2eea0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLFetch
       symbol_peflctx=0x83e2f700
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLFreeHandle
       symbol_peflctx=0x83e31330
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLFreeStmt
       symbol_peflctx=0x83e31340
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetData
       symbol_peflctx=0x83e32b60
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetEnvAttr
       symbol_peflctx=0x83e35f60
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetFunctions
       symbol_peflctx=0x83e36360
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLMoreResults
       symbol_peflctx=0x83e37ff0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLNumResultCols
       symbol_peflctx=0x83e38cc0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLParamData
       symbol_peflctx=0x83e39040
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLPutData
       symbol_peflctx=0x83e3b070
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLRowCount
       symbol_peflctx=0x83e3b510
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLSetEnvAttr
       symbol_peflctx=0x83e3d660
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLSetDescRec
       symbol_peflctx=0x83e3d420
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLColAttribute
       symbol_peflctx=0x83e22b50
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLColumns
       symbol_peflctx=0x83e244d0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLConnect
       symbol_peflctx=0x83e27f80
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLDescribeCol
       symbol_peflctx=0x83e29ef0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLDriverConnect
       symbol_peflctx=0x83e2b770
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLExecDirect
       symbol_peflctx=0x83e2e8c0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLForeignKeys
       symbol_peflctx=0x83e300e0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetConnectAttr
       symbol_peflctx=0x83e316e0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetDescField
       symbol_peflctx=0x83e33220
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetDescRec
       symbol_peflctx=0x83e33780
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagField
       symbol_peflctx=0x83e34a90
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagRec
       symbol_peflctx=0x83e35720
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetInfo
       symbol_peflctx=0x83e36e00
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetStmtAttr
       symbol_peflctx=0x83e37110
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLGetTypeInfo
       symbol_peflctx=0x83e37c20
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLPrepare
       symbol_peflctx=0x83e39870
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLPrimaryKeys
       symbol_peflctx=0x83e39dd0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLProcedureColumns
       symbol_peflctx=0x83e3a3f0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLProcedures
       symbol_peflctx=0x83e3aa90
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLSetConnectAttr
       symbol_peflctx=0x83e3b820
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLSetStmtAttr
       symbol_peflctx=0x83e3eba0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLSetDescField
       symbol_peflctx=0x83e3d050
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLStatistics
       symbol_peflctx=0x83e405a0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Entered hgolofns at 2012/10/10-11:45:04
       libname=/usr/lib64/libodbc.so, funcname=SQLTables
       symbol_peflctx=0x83e412c0
       hoaerr:0
      Exiting hgolofns at 2012/10/10-11:45:04
      Exiting hgolofn, rc=0 at 2012/10/10-11:45:04
      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 ".,"
      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
      Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
      treat_SQLLEN_as_compiled = 1
      Exiting hgoinit, rc=0 at 2012/10/10-11:45:04
      hostmstr:          0:      HOA After hoainit
      hostmstr:          0:      HOA Before hoalgon
      Entered hgolgon at 2012/10/10-11:45:04
       reco:0, name:sysdba, tflag:0
      Entered hgosuec at 2012/10/10-11:45:04
      Exiting hgosuec, rc=0 at 2012/10/10-11:45:04
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
       using sysdba as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2012/10/10-11:45:04
       HS_FDS_CONNECT_INFO = "vasco"
       HS_FDS_CONNECT_STRING = "CHARSET=ISO8859_2"
      Entered hgogenconstr at 2012/10/10-11:45:04
       dsn:vasco, name:sysdba
       optn:CHARSET=ISO8859_2
      Entered hgocip at 2012/10/10-11:45:04
       dsn:vasco
      Exiting hgocip, rc=0 at 2012/10/10-11:45:04
      ##>Connect Parameters (len=51)<##
      ## DSN=vasco;
      #! UID=sysdba;
      #! PWD=*
      ## CHARSET=ISO8859_2;
      Exiting hgogenconstr, rc=0 at 2012/10/10-11:45:04
      Entered hgolosf at 2012/10/10-11:45:05
      ODBC Function-Available-Array 0xFFFE 0x01FF 0xFF00 0xFFFF 0x03FF 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 
                                    0x0000 0x0000 0xFE00 0x3F5F 
      Exiting hgolosf, rc=0 at 2012/10/10-11:45:05
      DriverName:OdbcFb, DriverVer:02.00.0152
      DBMS Name:Firebird, DBMS Version:06.03.13318 LI-V Firebird 2.0
      Exiting hgocont, rc=0 at 2012/10/10-11:45:05
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2012/10/10-11:45:05
      hostmstr:          0:      HOA After hoalgon
      RPC Calling nscontrol(0), rc=0
      hostmstr:          0: RPC Before Upload Caps
      hostmstr:          0:      HOA Before hoaulcp
      Entered hgoulcp at 2012/10/10-11:45:05
      Entered hgowlst at 2012/10/10-11:45:05
      Exiting hgowlst, rc=0 at 2012/10/10-11:45:05
      SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
      TXN Capable:2, Isolation Option:0xf
      SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
      SQLGetInfo returns 31 for SQL_MAX_TABLE_NAME_LEN
      SQLGetInfo returns 31 for SQL_MAX_PROCEDURE_NAME_LEN
       HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER
      SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR  
      {code}
      
      *unixODBC trace file:*
      
      {code}
      [ODBC][22611][1349862304.638219][__handles.c][459]
                Exit:[SQL_SUCCESS]
                     Environment = 0x710370
      [ODBC][22611][1349862304.638257][SQLSetEnvAttr.c][189]
                Entry:
                     Environment = 0x710370
                     Attribute = SQL_ATTR_ODBC_VERSION
                     Value = 0x3
                     StrLen = -6
      [ODBC][22611][1349862304.638273][SQLSetEnvAttr.c][356]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862304.638511][SQLAllocHandle.c][375]
                Entry:
                     Handle Type = 2
                     Input Handle = 0x710370
      [ODBC][22611][1349862304.638528][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                     Output Handle = 0x74a240
      [ODBC][22611][1349862304.638572][SQLSetConnectAttr.c][396]
                Entry:
                     Connection = 0x74a240
                     Attribute = SQL_ATTR_AUTOCOMMIT
                     Value = (nil)
                     StrLen = -5
      [ODBC][22611][1349862304.638595][SQLSetConnectAttr.c][681]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862304.638827][SQLDriverConnect.c][701]
                Entry:
                     Connection = 0x74a240
                     Window Hdl = (nil)
                     Str In = [DSN=vasco;UID=sysdba;PWD=********;CHARSET=ISO8859_2][length = 51]
                     Str Out = 0x7493b0
                     Str Out Max = 1024
                     Str Out Ptr = 0x7fff1e4b7460
                     Completion = 0
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
      
      [ODBC][22611][1349862305.459802][SQLDriverConnect.c][1560]
                Exit:[SQL_SUCCESS]
                     Connection Out [DSN=vasco;Driver=Firebird/InterBase(r) driver;Dbname=fbspan.gora...]
      [ODBC][22611][1349862305.459977][SQLGetFunctions.c][151]
                Entry:
                     Connection = 0x74a240
                     Id = 999
                     Supported = 0x745820
      [ODBC][22611][1349862305.460014][SQLGetFunctions.c][186]
                Exit:[SQL_SUCCESS]
                     Supported = 0x745820 -> -2
      [ODBC][22611][1349862305.460176][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_DRIVER_NAME (6)
                     Info Value = 0x7fff1e4b7160
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b7464
      [ODBC][22611][1349862305.460218][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460253][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_DRIVER_VER (7)
                     Info Value = 0x7fff1e4b7160
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b7464
      [ODBC][22611][1349862305.460280][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460318][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_DBMS_NAME (17)
                     Info Value = 0x7fff1e4b7160
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b7464
      [ODBC][22611][1349862305.460345][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460434][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_DBMS_VER (18)
                     Info Value = 0x7fff1e4b7160
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b7464
      [ODBC][22611][1349862305.460466][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460539][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_CATALOG_NAME (10003)
                     Info Value = 0x7fff1e4b74c0
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b7750
      [ODBC][22611][1349862305.460604][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460662][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_MAX_CATALOG_NAME_LEN (34)
                     Info Value = 0x7fff1e4b774c
                     Buffer Length = 2
                     StrLen = (nil)
      [ODBC][22611][1349862305.460690][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.460741][SQLGetConnectAttr.c][292]
                Entry:
                     Connection = 0x74a240
                     Attribute = SQL_ATTR_CURRENT_CATALOG
                     Value = 0x767db0
                     Buffer Length = 4096
                     StrLen = 0x745ba0
      [ODBC][22611][1349862305.460778][SQLGetConnectAttr.c][758]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462108][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_SCHEMA_USAGE (91)
                     Info Value = 0x7fff1e4b7828
                     Buffer Length = 4
                     StrLen = 0x7fff1e4b783c
      [ODBC][22611][1349862305.462142][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462178][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_TXN_CAPABLE (46)
                     Info Value = 0x746114
                     Buffer Length = 2
                     StrLen = 0x7fff1e4b7844
      [ODBC][22611][1349862305.462204][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462229][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_TXN_ISOLATION_OPTION (72)
                     Info Value = 0x746118
                     Buffer Length = 4
                     StrLen = 0x7fff1e4b7844
      [ODBC][22611][1349862305.462272][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462311][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_MAX_SCHEMA_NAME_LEN (32)
                     Info Value = 0x7fff1e4b7840
                     Buffer Length = 2
                     StrLen = 0x7fff1e4b783c
      [ODBC][22611][1349862305.462337][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462393][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_MAX_TABLE_NAME_LEN (35)
                     Info Value = 0x7fff1e4b7840
                     Buffer Length = 2
                     StrLen = 0x7fff1e4b783c
      [ODBC][22611][1349862305.462473][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462542][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_MAX_PROCEDURE_NAME_LEN (33)
                     Info Value = 0x7fff1e4b7840
                     Buffer Length = 2
                     StrLen = 0x7fff1e4b783c
      [ODBC][22611][1349862305.462575][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462625][SQLGetInfo.c][554]
                Entry:
                     Connection = 0x74a240
                     Info Type = SQL_IDENTIFIER_QUOTE_CHAR (29)
                     Info Value = 0x7fff1e4b7580
                     Buffer Length = 512
                     StrLen = 0x7fff1e4b783c
      [ODBC][22611][1349862305.462653][SQLGetInfo.c][616]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.462715][SQLAllocHandle.c][540]
                Entry:
                     Handle Type = 3
                     Input Handle = 0x74a240
      [ODBC][22611][1349862305.462898][SQLAllocHandle.c][1083]
                Exit:[SQL_SUCCESS]
                     Output Handle = 0x76ff90
      [ODBC][22611][1349862305.462932][SQLBindCol.c][236]
                Entry:
                     Statement = 0x76ff90
                     Column Number = 1
                     Target Type = 1 SQL_CHAR
                     Target Value = 0x7fff1e4b7290
                     Buffer Length = 120
                     StrLen Or Ind = 0x7fff1e4b77d0
      [ODBC][22611][1349862305.463012][SQLBindCol.c][340]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.463044][SQLBindCol.c][236]
                Entry:
                     Statement = 0x76ff90
                     Column Number = 3
                     Target Type = -16 SQL_C_SLONG
                     Target Value = 0x7fff1e4b7824
                     Buffer Length = 0
                     StrLen Or Ind = 0x7fff1e4b77c0
      [ODBC][22611][1349862305.463070][SQLBindCol.c][340]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.463095][SQLBindCol.c][236]
                Entry:
                     Statement = 0x76ff90
                     Column Number = 10
                     Target Type = -15 SQL_C_SSHORT
                     Target Value = 0x7fff1e4b7838
                     Buffer Length = 0
                     StrLen Or Ind = 0x7fff1e4b77c8
      [ODBC][22611][1349862305.463120][SQLBindCol.c][340]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.463145][SQLGetTypeInfo.c][168]
                Entry:
                     Statement = 0x76ff90
                     Data Type = SQL_VARCHAR
      [ODBC][22611][1349862305.486751][SQLGetTypeInfo.c][318]
                Exit:[SQL_SUCCESS]
      [ODBC][22611][1349862305.486815][SQLFetch.c][162]
                Entry:
                     Statement = 0x76ff90 
      {code}
      
      From what I can understand by glancing the trace files dg4odbc dies after recieveing the first record(the column has only numeric values).
      Am I missing something or is this a bug?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
        • 1. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
          Mkirtley-Oracle
          Hi,
          Is thatthe full DG4ODBC trace you posted because I can't see any fetch errors ?
          Do you see the same problem if you comment out the parameter -

          HS_FDS_CONNECT_STRING = "CHARSET=ISO8859_2"

          Could you also post the odbcinst.ini file ?

          Regards,
          Mike
          • 2. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
            Kgronau-Oracle
            The connection dies at the connect handshake when Dg4ODBC checks out the capabilities of the foreign database, for example the supported data types (SQL_Varchar).

            In the past there were a couple of issues reported with the 64bit Firebird ODBC driver and they were resolved as soon as DG4ODCB was installed on a 32bit platform and the latest Firebird driver was used.


            From the trace it looks like we might hit here a similar issue. Maybe HS_FDS_SQLLEN_INTERPRETATION=32 and/or HS_FDS_FETCH_ROWS=1 might help.
            • 3. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
              AlesGolob
              Hi Mike.

              Yes that is the full DG4ODBC trace it just seems to crash on or after that SQLGetInfo call to get the SQL_IDENTIFIER_QUOTE_CHAR.
              I have tried removing the HS_FDS_CONNECT_STRING parameter but the error is exactly the same.

              my odbcinst.ini:
              [ODBC]
              Trace = yes
              TraceFile = /tmp/odbctrace.out
              
              [Firebird]
              Description     = ODBC for Firebird
              Driver          = /usr/lib64/unixODBC/libOdbcFb.so
              Setup           = /usr/lib64/unixODBC/libOdbcFb.so
              Threading       = 1
              FileUsage       = 1
              Regards,
              Aleš
              • 4. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                AlesGolob
                Hi.

                I have tried adding the HS_FDS_SQLLEN_INTERPRETATION and HS_FDS_FETCH_ROWS parameters as you mentioned but the error remains the same.

                I do have a full 64 bit Linux environment but is there a possibility to test the 32-bit edition without actually installing a 32-bit kernel and 32-bit edition of Oracle?

                Regards,
                Aleš
                • 5. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                  Kgronau-Oracle
                  As the Firebird ODBC driver is just a file I downloaded it for 64bit Linux and gave it a try.
                  It also reports an ORA-28511 when using select user from dual@<db link> .

                  So I did a more detailed analysis and found a core dump created which states:

                  ----- Call Stack Trace -----
                  calling call entry argument values in hex
                  location type point (? means dubious value)
                  -------------------- -------- -------------------- ----------------------------
                  shcstkdmp()+110 call kgdsdst() 000000000 ? 000000000 ?
                  7FFFFE8B5F98 ? 000000001 ?
                  000000001 ? 000000003 ?
                  hsssexhd()+85 call shcstkdmp() 000000000 ? 000000000 ?
                  7FFFFE8B5F98 ? 000000001 ?
                  000000001 ? 000000003 ?
                  __sighandler() call hsssexhd() 00000000B ? 000000000 ?
                  7FFFFE8B5F98 ? 000000001 ?
                  000000001 ? 000000003 ?
                  ZN15OdbcJdbcLibrar  signal   _sighandler() 005229FC0 ? 00524C540 ?
                  y11OdbcConvert21con 000000001 ? 00522B250 ?
                  vVarStringToStringE FEFEFEFEFEFEFEFF ?
                  PNS_10DescRecordES2 000004B8D ?
                  _()+312
                  ZN15OdbcJdbcLibrar  call     ZN15OdbcJdbcLibrar 005229C60 ? 005239C90 ?
                  y13OdbcStatement27r y11OdbcConvert21con 00522B250 ? 00522B250 ?
                  eturnDataFromExtend vVarStringToStringE FEFEFEFEFEFEFEFF ?
                  edFetchEv()+323 PNS_10DescRecordES2 000004B8D ?
                  _()
                  ZN15OdbcJdbcLibrar  call     ZN15OdbcJdbcLibrar 005229FC0 ? 005239C90 ?
                  y13OdbcStatement9fe y13OdbcStatement27r 00522B250 ? 00522B250 ?
                  tchDataEv()+721 eturnDataFromExtend FEFEFEFEFEFEFEFF ?
                  edFetchEv() 000004B8D ?
                  ZN15OdbcJdbcLibrar  call     ZN15OdbcJdbcLibrar 005229FC0 ? 005239C90 ?
                  y13OdbcStatement8sq y13OdbcStatement9fe 00522B250 ? 00522B250 ?
                  lFetchEv()+302 tchDataEv() FEFEFEFEFEFEFEFF ?
                  000004B8D ?
                  SQLFetch()+34 call _ZN15OdbcJdbcLibrar  005229FC0 ? 005239C90 ?
                  y13OdbcStatement8sq 00522B250 ? 00522B250 ?
                  lFetchEv() FEFEFEFEFEFEFEFF ?
                  000004B8D ?
                  SQLFetch()+212 call SQLFetch() 005229FC0 ? 005239C90 ?
                  00522B250 ? 00522B250 ?
                  FEFEFEFEFEFEFEFF ?
                  000004B8D ?


                  As it is in the ODBC function SQlFetch the ODBC vendor should check out the root cause of the issue.

                  - Klaus

                  Edited by: kgronau on Oct 10, 2012 2:56 PM

                  You can't install a 32bit DG4ODBC and ODBC driver on a 64bit OS, that's not supported.I'm sorry, but you really need to use a 32bit OS. Maybe you could just try it on a 32bit Windows machine?

                  - Klaus
                  • 6. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                    Kgronau-Oracle
                    You can't install a 32bit DG4ODBC and ODBC driver on a 64bit OS, that's not supported.I'm sorry, but you really need to use a 32bit OS. Maybe you could just try it on a 32bit Windows machine?

                    - Klaus
                    • 7. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                      AlesGolob
                      I'm still working on setting up a 32-bit testing environment but in the meantime the folks at Easysoft were so good to provide me with a pre-release version of their 64-bit Firebird ODBC driver.

                      Now short resultsets, bellow 100 rows, are fine but if I select more than 100 rows I get the previous error ORA-28511.

                      odbc trace:
                      [ODBC][21781][1349964375.084986][__handles.c][459]
                                Exit:[SQL_SUCCESS]
                                     Environment = 0x70fdf0
                      [ODBC][21781][1349964375.085017][SQLSetEnvAttr.c][189]
                                Entry:
                                     Environment = 0x70fdf0
                                     Attribute = SQL_ATTR_ODBC_VERSION
                                     Value = 0x3
                                     StrLen = -6
                      [ODBC][21781][1349964375.085031][SQLSetEnvAttr.c][356]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.085248][SQLAllocHandle.c][375]
                                Entry:
                                     Handle Type = 2
                                     Input Handle = 0x70fdf0
                      [ODBC][21781][1349964375.085265][SQLAllocHandle.c][493]
                                Exit:[SQL_SUCCESS]
                                     Output Handle = 0x74c250
                      [ODBC][21781][1349964375.085286][SQLSetConnectAttr.c][396]
                                Entry:
                                     Connection = 0x74c250
                                     Attribute = SQL_ATTR_AUTOCOMMIT
                                     Value = (nil)
                                     StrLen = -5
                      [ODBC][21781][1349964375.085303][SQLSetConnectAttr.c][681]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.085485][SQLDriverConnect.c][701]
                                Entry:
                                     Connection = 0x74c250
                                     Window Hdl = (nil)
                                     Str In = [DSN=vasco_2;UID=sysdba;PWD=********][length = 35]
                                     Str Out = 0x74e338
                                     Str Out Max = 1024
                                     Str Out Ptr = 0x7fff92f3bba0
                                     Completion = 0
                                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
                      
                      [ODBC][21781][1349964375.137237][SQLDriverConnect.c][1560]
                                Exit:[SQL_SUCCESS]
                                     Connection Out [[DSN=vasco_2;UID=sysdba;PWD=********][length = 35 (SQL_NTS)]]
                      [ODBC][21781][1349964375.137398][SQLGetFunctions.c][151]
                                Entry:
                                     Connection = 0x74c250
                                     Id = 999
                                     Supported = 0x70f2c0
                      [ODBC][21781][1349964375.137435][SQLGetFunctions.c][186]
                                Exit:[SQL_SUCCESS]
                                     Supported = 0x70f2c0 -> -2
                      [ODBC][21781][1349964375.137615][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_DRIVER_NAME (6)
                                     Info Value = 0x7fff92f3b8a0
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3bba4
                      [ODBC][21781][1349964375.137664][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.137716][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_DRIVER_VER (7)
                                     Info Value = 0x7fff92f3b8a0
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3bba4
                      [ODBC][21781][1349964375.137744][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.137784][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_DBMS_NAME (17)
                                     Info Value = 0x7fff92f3b8a0
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3bba4
                      [ODBC][21781][1349964375.137811][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.137841][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_DBMS_VER (18)
                                     Info Value = 0x7fff92f3b8a0
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3bba4
                      [ODBC][21781][1349964375.137872][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.137951][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_CATALOG_NAME (10003)
                                     Info Value = 0x7fff92f3bc00
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3be90
                      [ODBC][21781][1349964375.137980][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.142775][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_SCHEMA_USAGE (91)
                                     Info Value = 0x7fff92f3bf68
                                     Buffer Length = 4
                                     StrLen = 0x7fff92f3bf7c
                      [ODBC][21781][1349964375.142823][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.142867][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_TXN_CAPABLE (46)
                                     Info Value = 0x70fbb4
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3bf84
                      [ODBC][21781][1349964375.142897][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.142927][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_TXN_ISOLATION_OPTION (72)
                                     Info Value = 0x70fbb8
                                     Buffer Length = 4
                                     StrLen = 0x7fff92f3bf84
                      [ODBC][21781][1349964375.142954][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.142998][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_MAX_SCHEMA_NAME_LEN (32)
                                     Info Value = 0x7fff92f3bf80
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3bf7c
                      [ODBC][21781][1349964375.143026][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.143066][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_MAX_TABLE_NAME_LEN (35)
                                     Info Value = 0x7fff92f3bf80
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3bf7c
                      [ODBC][21781][1349964375.143115][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.143156][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_MAX_PROCEDURE_NAME_LEN (33)
                                     Info Value = 0x7fff92f3bf80
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3bf7c
                      [ODBC][21781][1349964375.143212][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.143275][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_IDENTIFIER_QUOTE_CHAR (29)
                                     Info Value = 0x7fff92f3bcc0
                                     Buffer Length = 512
                                     StrLen = 0x7fff92f3bf7c
                      [ODBC][21781][1349964375.143305][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.143369][SQLAllocHandle.c][540]
                                Entry:
                                     Handle Type = 3
                                     Input Handle = 0x74c250
                      [ODBC][21781][1349964375.144529][SQLAllocHandle.c][1083]
                                Exit:[SQL_SUCCESS]
                                     Output Handle = 0x76d320
                      [ODBC][21781][1349964375.144576][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 1
                                     Target Type = 1 SQL_CHAR
                                     Target Value = 0x7fff92f3b9d0
                                     Buffer Length = 120
                                     StrLen Or Ind = 0x7fff92f3bf10
                      [ODBC][21781][1349964375.144610][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.144639][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 3
                                     Target Type = -16 SQL_C_SLONG
                                     Target Value = 0x7fff92f3bf64
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3bf00
                      [ODBC][21781][1349964375.144675][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.144704][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 10
                                     Target Type = -15 SQL_C_SSHORT
                                     Target Value = 0x7fff92f3bf78
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3bf08
                      [ODBC][21781][1349964375.144748][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.144778][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_VARCHAR
                      [ODBC][21781][1349964375.152548][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.152601][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.153524][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.153563][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.153606][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.153639][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.154295][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.154334][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_INTEGER
                      [ODBC][21781][1349964375.157687][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.157712][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.158467][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.158493][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.158518][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.158537][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.159192][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.159217][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_INTEGER
                      [ODBC][21781][1349964375.162162][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.162208][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.163260][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.163286][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.163904][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.163929][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_SMALLINT
                      [ODBC][21781][1349964375.166934][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.166960][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.167731][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.167754][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.167791][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.167810][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.168468][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.168492][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_SMALLINT
                      [ODBC][21781][1349964375.171429][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.171457][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.172225][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.172250][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.172826][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.172850][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_VARBINARY
                      [ODBC][21781][1349964375.175761][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.175788][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.176554][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.176581][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.177185][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.177212][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_BIGINT
                      [ODBC][21781][1349964375.180278][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.180304][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.181041][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.181066][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.181091][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.181110][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.181752][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.181779][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_BIGINT
                      [ODBC][21781][1349964375.184685][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.184716][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.185431][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.185461][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.186128][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.186154][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_TINYINT
                      [ODBC][21781][1349964375.189124][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.189153][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.189882][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.189908][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.190478][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.190506][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_LONGVARCHAR
                      [ODBC][21781][1349964375.193484][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.193511][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.194303][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.194329][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.194959][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.194984][SQLGetTypeInfo.c][168]
                                Entry:
                                     Statement = 0x76d320
                                     Data Type = SQL_LONGVARBINARY
                      [ODBC][21781][1349964375.198018][SQLGetTypeInfo.c][318]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.198047][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.198806][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.198832][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.199393][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.199431][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 2
                      [ODBC][21781][1349964375.199449][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.202595][SQLEndTran.c][419]
                                Entry:            
                                     Connection = 0x74c250            
                                     Completion Type = 0
                      [ODBC][21781][1349964375.202628][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_CURSOR_COMMIT_BEHAVIOR (23)
                                     Info Value = 0x74d6c0
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3be4e
                      [ODBC][21781][1349964375.202649][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.202669][SQLGetInfo.c][554]
                                Entry:
                                     Connection = 0x74c250
                                     Info Type = SQL_CURSOR_ROLLBACK_BEHAVIOR (24)
                                     Info Value = 0x74d6c2
                                     Buffer Length = 2
                                     StrLen = 0x7fff92f3be4e
                      [ODBC][21781][1349964375.202686][SQLGetInfo.c][616]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.202703][SQLEndTran.c][628]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.202726][SQLSetConnectAttr.c][396]
                                Entry:
                                     Connection = 0x74c250
                                     Attribute = SQL_ATTR_TXN_ISOLATION
                                     Value = 0x2
                                     StrLen = -5
                      [ODBC][21781][1349964375.202744][SQLSetConnectAttr.c][852]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.204441][SQLAllocHandle.c][540]
                                Entry:
                                     Handle Type = 3
                                     Input Handle = 0x74c250
                      [ODBC][21781][1349964375.205106][SQLAllocHandle.c][1083]
                                Exit:[SQL_SUCCESS]
                                     Output Handle = 0x76fcf0
                      [ODBC][21781][1349964375.205139][SQLFreeHandle.c][385]
                                Entry:
                                     Handle Type = 3
                                     Input Handle = 0x76d320
                      [ODBC][21781][1349964375.205875][SQLFreeHandle.c][497]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.205921][SQLAllocHandle.c][540]
                                Entry:
                                     Handle Type = 3
                                     Input Handle = 0x74c250
                      [ODBC][21781][1349964375.206607][SQLAllocHandle.c][1083]
                                Exit:[SQL_SUCCESS]
                                     Output Handle = 0x76d320
                      [ODBC][21781][1349964375.206638][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 4
                                     Target Type = 1 SQL_CHAR
                                     Target Value = 0x7fff92f3bda0
                                     Buffer Length = 124
                                     StrLen Or Ind = 0x7fff92f3be78
                      [ODBC][21781][1349964375.206660][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206679][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 5
                                     Target Type = -15 SQL_C_SSHORT
                                     Target Value = 0x7fff92f3bf40
                                     Buffer Length = 0
                                     StrLen Or Ind = (nil)
                      [ODBC][21781][1349964375.206699][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206718][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 6
                                     Target Type = 1 SQL_CHAR
                                     Target Value = 0x7fff92f3bd10
                                     Buffer Length = 120
                                     StrLen Or Ind = 0x7fff92f3bea0
                      [ODBC][21781][1349964375.206819][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206879][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 7
                                     Target Type = -16 SQL_C_SLONG
                                     Target Value = 0x7fff92f3bf1c
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3be80
                      [ODBC][21781][1349964375.206900][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206918][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 9
                                     Target Type = -15 SQL_C_SSHORT
                                     Target Value = 0x7fff92f3bf44
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3be88
                      [ODBC][21781][1349964375.206942][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206961][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 10
                                     Target Type = -15 SQL_C_SSHORT
                                     Target Value = 0x7fff92f3bf4c
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3bea8
                      [ODBC][21781][1349964375.206980][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.206999][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 11
                                     Target Type = -15 SQL_C_SSHORT
                                     Target Value = 0x7fff92f3bf48
                                     Buffer Length = 0
                                     StrLen Or Ind = (nil)
                      [ODBC][21781][1349964375.207019][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.207037][SQLBindCol.c][236]
                                Entry:
                                     Statement = 0x76d320
                                     Column Number = 16
                                     Target Type = -16 SQL_C_SLONG
                                     Target Value = 0x7fff92f3bf28
                                     Buffer Length = 0
                                     StrLen Or Ind = 0x7fff92f3be90
                      [ODBC][21781][1349964375.207127][SQLBindCol.c][340]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.207154][SQLColumns.c][215]
                                Entry:
                                     Statement = 0x76d320
                                     Catalog Name = [NULL]
                                     Schema Name = [NULL]
                                     Table Name = [DRZAVA][length = 6]
                                     Column Name = [NULL]
                      [ODBC][21781][1349964375.234695][SQLColumns.c][412]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.235327][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.237120][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.237261][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.238634][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.238712][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.239957][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.240028][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.241338][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.241407][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.242603][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.242670][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.243957][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.244036][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.245297][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.245364][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.246732][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.246822][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.248092][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.248160][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.249455][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.249536][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.250790][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.250857][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.252068][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.252140][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.253373][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.253444][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.254694][SQLFetch.c][348]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.254764][SQLFetch.c][162]
                                Entry:
                                     Statement = 0x76d320
                      [ODBC][21781][1349964375.255413][SQLFetch.c][348]
                                Exit:[SQL_NO_DATA]
                      [ODBC][21781][1349964375.255454][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 0
                      [ODBC][21781][1349964375.256028][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.256051][SQLFreeStmt.c][144]
                                Entry:
                                     Statement = 0x76d320
                                     Option = 2
                      [ODBC][21781][1349964375.256067][SQLFreeStmt.c][263]
                                Exit:[SQL_SUCCESS]
                      [ODBC][21781][1349964375.256189][SQLFreeHandle.c][385]
                                Entry:
                                     Handle Type = 3
                                     Input Handle = 0x76fcf0
                      [ODBC][21781][1349964375.256750][SQLFreeHandle.c][497]
                                Exit:[SQL_SUCCESS]
                      [ODBC][12905][1349964426.374992][SQLEndTran.c][419]
                                Entry:            
                                     Connection = 0x74a260            
                                     Completion Type = 1 
                      The relevant part of the dg4odbc trace file:
                       SQLFetch: row: 100, column 1, bflsz: 528, bflar: 8
                       SQLFetch: row: 100, column 1, bflsz: 528, bflar: 8, (bfl: 8, mbl: 4)
                       SQLFetch: row: 100, column 2, bflsz: 530, bflar: 30
                       SQLFetch: row: 100, column 2, bflsz: 530, bflar: 30, (bfl: 30, mbl: 30)
                       SQLFetch: row: 100, column 3, bflsz: 533, bflar: 5
                       SQLFetch: row: 100, column 3, bflsz: 533, bflar: 5, (bfl: 5, mbl: 5)
                       SQLFetch: row: 100, column 4, bflsz: 540, bflar: 8
                       SQLFetch: row: 100, column 4, bflsz: 540, bflar: 8, (bfl: 8, mbl: 4)
                       SQLFetch: row: 100, column 5, bflsz: 548, bflar: 30
                       SQLFetch: row: 100, column 5, bflsz: 548, bflar: 30, (bfl: 30, mbl: 30)
                       SQLFetch: row: 100, column 6, bflsz: 554, bflar: 40
                       SQLFetch: row: 100, column 6, bflsz: 554, bflar: 40, (bfl: 40, mbl: 40)
                       SQLFetch: row: 100, column 7, bflsz: 558, bflar: 8
                       SQLFetch: row: 100, column 7, bflsz: 558, bflar: 8, (bfl: 8, mbl: 8)
                       SQLFetch: row: 100, column 8, bflsz: 562, bflar: 40
                       SQLFetch: row: 100, column 8, bflsz: 562, bflar: 40, (bfl: 40, mbl: 40)
                       SQLFetch: row: 100, column 9, bflsz: 566, bflar: 8
                       SQLFetch: row: 100, column 9, bflsz: 566, bflar: 8, (bfl: 8, mbl: 4)
                       SQLFetch: row: 100, column 10, bflsz: 570, bflar: 8
                       SQLFetch: row: 100, column 10, bflsz: 570, bflar: 8, (bfl: 8, mbl: 4)
                       SQLFetch: row: 100, column 11, bflsz: 574, bflar: 80
                       SQLFetch: row: 100, column 11, bflsz: 574, bflar: 80, (bfl: 80, mbl: 80)
                       SQLFetch: row: 100, column 12, bflsz: 578, bflar: 80
                       SQLFetch: row: 100, column 12, bflsz: 578, bflar: 80, (bfl: 80, mbl: 80)
                       SQLFetch: row: 100, column 13, bflsz: 580, bflar: -1
                       SQLFetch: row: 100, column 13, bflsz: 580, bflar: SQL_NULL_DATA
                       SQLFetch: row: 100, column 14, bflsz: 581, bflar: 40
                       SQLFetch: row: 100, column 14, bflsz: 581, bflar: 40, (bfl: 40, mbl: 40)
                       100 rows fetched
                      Exiting hgoftch, rc=0 at 2012/10/11-15:24:15
                      hostmstr:          0:   HOA After hoaftch
                      So from what I can gather the first 100 rows are fetched and then the whole thing crashes.

                      So is this an error of the ODBC driver or is this a problem with dg4odbc fetching the next part od the data?

                      Regards,
                      Aleš
                      • 8. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                        Mkirtley-Oracle
                        Hi,
                        If you set the gateway parameter -

                        HS_FDS_FETCH_ROWS=200

                        so it fetches more rows than the default of 100 do you then see the same error ?

                        Regards,
                        Mike
                        • 9. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                          AlesGolob
                          I've tried raising that parameter to 300 and this time even though all the 251 rows from that table were transferred the error remained the same. But if I selected just a few columns from that table all of the 251 rows were returned by oracle even thought judging from the trace file the ODBC driver returns all the columns to DG4ODBC.
                          So I reduced the HS_FDS_FETCH_ROWS to about 30 and now more or less everything works as expected. So I guess the problem is in the result set buffer being to little or static.

                          I don't know much about ODBC or DG4ODBC so I don't know if the problem is related to the ODBC driver or is it on the dg4odbc's side, but in any case it would be good to find out where the problem exactly lies.

                          Regards,
                          Aleš
                          • 10. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                            Mkirtley-Oracle
                            Aleš,
                            You probably expect us to say this but I suspect the problem is more likely with the ODBC driver than DG4ODBC.
                            We haven't had any reports of the same problem with DG4ODBC and other drivers and as you said it was a pre-release version so it is more likely to be the driver. I suggest you contact Firebird and see what they have to say.
                            We could follow up in a bug but you would need to open a SR in My Oracle Support for us to do that.

                            Are there any drivers from other vendors that you could use as a test ?

                            Regards,
                            Mike
                            • 11. Re: Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails
                              Kgronau-Oracle
                              Root cause of this problem is an issue in the ODBC driver having problems with the extended fetch. There are a couple of ODBC driver vendors who do not support extended fetching of record sets and for all of these vendors DG4ODBC has the option to set HS_FDS_FETCH_ROWS=1 in the gateway init file. It surely decreases the performance as you need a roundtrip for every record, but at least it allows you to fetch the data.