Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle 10.2.03 64bit and dg4odbc in gateway 11

537898Mar 6 2008 — edited Mar 9 2008
Hi,
we want to implement a connection to our informix server
from oracle 10.2 64bit on a SuSE SLES10 64bit machine.

So i installed the gateway services for oracle 11g
I also installed the required patch 5965763
and configured the listener.ora (extract):
---------------------------------------------------------
...
(SID_DESC =
(SID_NAME=IFAX)
(ORACLE_HOME=/opt/oracle/product/11)
(PROGRAM=dg4odbc) (ENVS=LD_LIBRARY_PATH=/opt/oracle/product/11/dg4/driver/lib:/opt/oracle/product/11/lib)
)
....
---------------------------------------------------------
and tnsnames.ora (extract):
---------------------------------------------------------
...
IFAXODBC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tq-ifsrv-neu.tq-net.de)(PORT = 1521))
(CONNECT_DATA =
(SID = IFAX)
)
(HS=OK)
)
....
---------------------------------------------------------
and the initIFAX.ora :
---------------------------------------------------------
HS_FDS_CONNECT_INFO = IFAX0001
HS_FDS_TRACE_LEVEL = debug
HS_FDS_SHAREABLE_NAME = /usr/local/informix/lib/cli/libifcli.so
set ODBCINI=/etc/unixODBC/odbc.ini
set LD_LIBRARY_PATH=/usr/local/informix/lib/cli:/usr/local/informix/lib/esql:$LD_LIBRARY_PATH
set INFORMIXDIR=/usr/local/informix
---------------------------------------------------------

The odbc-driver is working fine (tested with:isql -v IFAX0001)

In oracle i got the message:
---------------------------------------------------------
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 IFAX
---------------------------------------------------------

What is going wrong here?

Regards Lothar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2008
Added on Mar 6 2008
8 comments
5,112 views