This discussion is archived
11 Replies Latest reply: Oct 14, 2012 10:00 PM by kgronau RSS

Connection from Oracle 11gR2 to Firebird 2.0.7 using dg4odbc fails

AlesGolob Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points