Skip to content

Latest commit

 

History

History
101 lines (90 loc) · 3.01 KB

ODBC_guide.md

File metadata and controls

101 lines (90 loc) · 3.01 KB
Raw

Informix ODBC seems to have versatile behavior and may vary on driver version and system setup. This article will give you an example as reference point.
Environment: Ubuntu 18.04 x64, SDK 4.50.FC3.

  • Get Informix Client SDK from IBM site and install it. Let's assume installation path is /opt/IBM/informix.
  • Install packages apt install unixodbc-dev unixodbc and python module pip3 install pyodbc.
  • Check ODBC configuration files location with odbcinst -j command.
unixODBC 2.3.4
DRIVERS............: /etc/odbcinst.ini  
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini

Look at DRIVERS and SYSTEM DATA SOURCES variables. We will register drivers systemwide but you can use file DSN as well.

/etc/odbc.ini

[ODBC Data Sources]
uccx
uccx2

[uccx]
DRIVER={IBM INFORMIX ODBC DRIVER (64-bit)}
UID=uccxhruser
PWD=yourpassword
DATABASE=db_cra
HOST=uccx
SERVER=uccx_uccx
SERVICE=1504
PROTOCOL=onsoctcp
CLIENT_LOCALE=en_US.UTF8
DB_LOCALE=en_US.UTF8

[uccx2]
DRIVER={IBM INFORMIX ODBC DRIVER 2 (64-bit)}
UID=uccxhruser
PWD=password
DATABASE=db_cra
HOST=uccx2
SERVER=uccx2_uccx
SERVICE=1504
PROTOCOL=onsoctcp
CLIENT_LOCALE=en_US.UTF8
DB_LOCALE=en_US.UTF8

/etc/odbcinst.ini

[IBM INFORMIX ODBC DRIVER (64-bit)]
Driver=/opt/IBM/informix/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
UID=uccxhruser
PWD=yourpassword
DATABASE=db_cra
HOST=uccx
SERVER=uccx_uccx
SERVICE=1504
PROTOCOL=onsoctcp
CLIENT_LOCALE=en_US.UTF8
DB_LOCALE=en_US.UTF8

[IBM INFORMIX ODBC DRIVER 2 (64-bit)]
Driver=/opt/IBM/informix/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
UID=uccxhruser
PWD=yourpassword
DATABASE=db_cra
HOST=uccx2
SERVER=uccx2_uccx
SERVICE=1504
PROTOCOL=onsoctcp
CLIENT_LOCALE=en_US.UTF8
DB_LOCALE=en_US.UTF8

Also sqlhosts definition might be reqired at /opt/IBM/informix/etc/sqlhosts

uccx_uccx onsoctcp uccx 1504
uccx2_uccx onsoctcp uccx2 1504

Check your drivers with odbcinst -q -d command.
Also it is supposed to test drivers with isql -v uccx command but in my case I get error even on working drivers.

  • If you have error messages about libs check it like
ldd -v /opt/IBM/informix/lib/cli/iclis09b.so

It should not contain 'not found' output. Sometimes it is required to create symlink from $INFORMIXDIR/lib/esql/somelib.so to $INFORMIXDIR/lib/cli/somelib.so.

  • When running driver following environment variables must be declared:
export INFORMIXDIR=/opt/IBM/informix
export LD_LIBRARY_PATH=/opt/IBM/informix/lib:/opt/IBM/informix/lib/cli:/opt/IBM/informix/lib/esql
export INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts

You can put it to ~/.profile file for user or /etc/environment for system-wide. Don't use nested variables, it won't work in some scenarios!