Two things stand out to me:
1. Your /etc/odbcinst.ini needs this line:
IBM Informix ODBC DRIVER=Installed
2. You need to specify the driver in /etc/odbc.ini:
Change "Driver=Informix" to
Driver=/full/path/to/iclit09b.so
See my working example below.
In the system-wide ODBC drivers config file /etc/odbcinst.ini:
;-----------------------------------------------------------------------
; Section 1: List of ODBC drivers installed on the system
[ODBC Drivers]
IBM Informix ODBC DRIVER=Installed
;-----------------------------------------------------------------------
; Section 2: List of properties for specific ODBC driver(s).
[IBM Informix ODBC DRIVER]
Description=IBM Informix ODBC Driver
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
;-----------------------------------------------------------------------
; Section 3: ODBC global options such as Unicode or Tracing
[ODBC]
Trace = no
TraceFile = /tmp/odbctrace.log
I put my individual connection setups in ~/.odbc.ini but these should
work for system-wide use in /etc/odbc.ini:
[stores_demo]
Description=IBM Informix 12.10 stores_demo database via ODBC
Driver=/opt/informix/lib/cli/iclit09b.so
Database=stores_demo
; Informix uses OS authentication, so does not need LogonID or pwd,
; if the client is on the same system as the database server.
; Might need this if connecting remotely (UNTESTED).
;LogonID=odbc
;pwd=odbc
Servername=ids12de
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so
Notes:
* Make /opt/informix a symlinks to your installed version of Informix
(e.g., /opt/ibm/informix/ids12.10.FC16W1DE) so you don't have to
update the ODBC configuration files if/when Informix is upgraded.
* I'm only using a local connection, not over TCP/IP, but your Host,
Service, Protocol, UID look OK.
* Set Trace=yes in /etc/odbcinst.ini (Section 3) to help debug.
The log file is whatever you set TraceFile to, /tmp/odbctrace.log
in my example.
scot