Oninit cdi / Archive
Talk to an expert →

Connecting to IDS 9.4 from Linux x86_64

Posted in 2007

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues, Internationalization & Character Sets, Versions, Editions & End-of-Life

CAMERON ZEMEK — — source: IIUG Forums & Mailing Lists

downloaded the informix client sdk 2.9 for x86_64 (the RHEL 3, 64bit download). However, I can't connect to the database (which is working with the 32bit version on different machine). $ isql -v mydb[ISQL]ERROR: Could not SQLConnect $ cat /etc/odbc.iniODBC Data Sources] mydb=INFORMIX ; ; Define ODBC Database Driver's Below - Driver Configuration Section ; [authlive] Driver=/opt/informix/x86_64/lib/cli/iclis09b.so Description=INFORMIX Database=databaseserver LogonID=auth pwd=**** Servername=mydb CursorBehavior=0 CLIENT_LOCALE=en_us.8859-1DB_LOCALE= en_us.8859-1 TRANSLATIONDLL=/opt/informix/x86_64/lib/esql/igo4a304.so [ODBC] ;uncomment the below line for UNICODE connection ;UNICODE=UCS-4 Trace=1 TraceFile=/tmp/odbctrace.out Inst allDir=/opt/informix/x86_64 $ cat /etc/odbcinst.ini [ODBC Drivers] INFORMIX=Installed [INFORMIX] Driver=/opt/informix/x86_64 /lib/cli/iclit09b.so Setup=/opt/informix/x86_64/lib/cli/iclit09b.so APILev el=1 ConnectFunctions=YYY DriverODBCVer=03.81 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y

↪ replying to CAMERON ZEMEK
CAMERON ZEMEK — — source: IIUG Forums & Mailing Lists

[authlive] should read [mydb]

↪ replying to CAMERON ZEMEK
ART KAGEL, — — source: IIUG Forums & Mailing Lists

isql does not use ODBC it uses ESQL/C. You have to set up the sqlhosts file to point to the server. Art S. Kagel ----- Original Message ----- From: Cameron Zemek <ids@iiug.org> At: 5/07 18:35:32 downloaded the informix client sdk 2.9 for x86_64 (the RHEL 3, 64bit download). However, I can't connect to the database (which is working with the 32bit version on different machine). $ isql -v mydb[ISQL]ERROR: Could not SQLConnect $ cat /etc/odbc.iniODBC Data Sources] mydb=INFORMIX ; ; Define ODBC Database Driver's Below - Driver Configuration Section ; [authlive] Driver=/opt/informix/x86_64/lib/cli/iclis09b.so Description=INFORMIX Database=databaseserver LogonID=auth pwd=**** Servername=mydb CursorBehavior=0 CLIENT_LOCALE=en_us.8859-1DB_LOCALE= en_us.8859-1 TRANSLATIONDLL=/opt/informix/x86_64/lib/esql/igo4a304.so [ODBC] ;uncomment the below line for UNICODE connection ;UNICODE=UCS-4 Trace=1 TraceFile=/tmp/odbctrace.out Inst allDir=/opt/informix/x86_64 $ cat /etc/odbcinst.ini [ODBC Drivers] INFORMIX=Installed [INFORMIX] Driver=/opt/informix/x86_64 /lib/cli/iclit09b.so Setup=/opt/informix/x86_64/lib/cli/iclit09b.so APILev el=1 ConnectFunctions=YYY DriverODBCVer=03.81 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to ART KAGEL,
CAMERON ZEMEK — — source: IIUG Forums & Mailing Lists

isql is the tool that comes with unixODBC. Anyway I do have sqlhosts setup as follows: $ cat /opt/informix/x86_64/etc/sqlhostsmydb onsoctcp databaseserver sqlexec1 $ tail /etc/servicessqlexec1 1541/tcp $ env INFORMIXSQLHOSTS=/opt/informix/x86_64/etc/sqlhosts INFORMIXSERVER=mydb INFORMIXDIR=/opt/informix/x86_64 PATH=/usr/java/default/bin:/opt/informix/x86_64/bin:/usr/kerberos/bin:/usr/java/ default/bin:/opt/informix/x86_64/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin :/home/grom/bin LD_LIBRARY_PATH=/opt/informix/x86_64/lib:/opt/informix/x86_64/lib/cli:/opt/infor mix/x86_64/lib/esql

↪ replying to ART KAGEL,
CAMERON ZEMEK — — source: IIUG Forums & Mailing Lists

Additionally I can connect using the trail download of the DataDirect drivers, however looking for a solution that works with the informix client SDK driver or a free license solution.

Glossary