Oracle Database Discussions

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

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

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

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

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

-----


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

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

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


Heterogeneous Agent Release
11.1.0.6.0




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

Version 11.1.0.6.0

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

Any ideas?

Thanks!