Unix ODBC connection to IDS engine

What I remember to be very simple years ago is stumping me currently. IDS 11.5FC8, CSDK 4.10, AIX 7.1. Simply trying to create ODBC connectivity on that box (to allow Golden Gate to do replication from IFMX to that other database). Created/edited the odbc.ini and odcinst.ini files; defined ODBCINI env var to point to odbc.ini. Using isql to test the connection: "isql [dsn name] informix [pwd]" but it appears that isql isn't using the ODBC connection since it thinks the dsn name is a database, etc. (as if you passed an invalid database name). Again, this is all on the same box but I'm using a soctcp connection since doing local loopback (which I can't imagine matters). What am I missing? Thanks in advance - Mark Scranton mark@markscranton.com The Mark Scranton Group 765-729-2601

Hello, here is what i do and works: *Odbcinst.ini * [ODBC Drivers] IBM INFORMIX ODBC DRIVER=Installed [IBM INFORMIX ODBC DRIVER] Driver=/opt/IBM/informix/lib/cli/iclit09b.so Setup=/opt/IBM/informix/lib/cli/iclit09b.so APILevel=1 ConnectFunctions=YYY DriverODBCVer=03.51 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y *odbc.ini * [siglo] Driver=IBM INFORMIX ODBC DRIVER Description=as Database=as Servername=server_tcp cd /etc/ld.so.conf.d vim informix.conf /opt/IBM/informix/lib/cli /opt/IBM/informix/lib/esql /opt/IBM/informix/lib Write and quit execute ldconfig export your INFORMIX var and isql -v as user password REgards On 17/05/16 23:07, MARK SCRANTON wrote: > What I remember to be very simple years ago is stumping me currently. IDS > 11.5FC8, CSDK 4.10, AIX 7.1. Simply trying to create ODBC connectivity on that > box (to allow Golden Gate to do replication from IFMX to that other database). > Created/edited the odbc.ini and odcinst.ini files; defined ODBCINI env var to > point to odbc.ini. Using isql to test the connection: > "isql [dsn name] informix [pwd]" but it appears that isql isn't using the ODBC > connection since it thinks the dsn name is a database, etc. (as if you passed > an invalid database name). Again, this is all on the same box but I'm using a > soctcp connection since doing local loopback (which I can't imagine matters). > > What am I missing? > > Thanks in advance - > Mark Scranton > mark@markscranton.com > The Mark Scranton Group > 765-729-2601 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >