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?