Connecting to informix

Support for the other architectures (X86_64, IA-64, and PowerPC)
Post Reply
grom358
Posts: 4
Joined: 2007/05/09 06:30:05

Connecting to informix

Post by grom358 » 2007/05/09 22:14:13

I downloaded and installed the 64bit informix client SDK as follows:

# mkdir /opt/informix
# useradd -d /opt/informix -s /sbin/nologin informix
# chown informix:informix /opt/informix
# tar -xvf ~/clientsdk.2.90.FC4R1.LINUX.tar -C /opt/informix
# export INFORMIXDIR=/opt/informix
# export INFORMIXSERVER=dbserver
# /opt/informix/install_rpm -acceptlicense=yes

I setup config files as follows:
$ cat /etc/profile.d/informix.sh
export INFORMIXDIR=/opt/informix
export PATH=${INFORMIXDIR}/bin:${PATH}
export INFORMIXSERVER=dbserver
export INFORMIXSQLHOSTS=${INFORMIXDIR}/etc/sqlhosts
export LD_LIBRARY_PATH=${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/cli:${INFORMIXDIR}/lib/esql
export OPTCOMPIND=0

$ cat /opt/informix/etc/sqlhosts
mydb onsoctcp dbserver sqlexec1

$ cat /etc/odbc.ini
[ODBC Data Sources]
mydb=INFORMIX

[mydb]
Driver=/opt/informix/lib/cli/iclis09b.so
Description=INFORMIX
Database=mydb
LogonID=auth
pwd=XXXX
Servername=mydb
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so

[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
Trace=1
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/informix

$ cat /etc/odbcinst.ini
[ODBC Drivers]
INFORMIX=Installed

[INFORMIX]
Driver=/opt/informix/lib/cli/iclit09b.so
Setup=/opt/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y

// After reloading shell.
$ isql -v mydb
[ISQL]ERROR: Could not SQLConnect

Please help me

Post Reply

Return to “CentOS 5 - X86_64,s390(x) and PowerPC Support”