Connecting to IDS 9.4 from Linux x86_64
Cameron Zemek could not connect with isql -v to IDS 9.4 using Client SDK 2.9 on x86_64 Linux (Could not SQLConnect). Art Kagel said isql uses ESQL/C and needs sqlhosts; Cameron replied that isql is the unixODBC tool and his sqlhosts and environment were set. DataDirect trial drivers worked but he wanted the Informix driver. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
[authlive] should read [mydb]
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.
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
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.