[unixODBC-support] unixODBC and Informix

Nick Gorham nick.gorham at easysoft.com
Tue Jul 8 18:15:42 BST 2008

Don_Arnett at ned.uscourts.gov wrote:

>I've determined that even tho $ODBCINI is pointing to /etc/odbc.ini, 
>./isql is using /etc/unixODBC/odbc.ini.  Once I moved odbc.ini to 
>/etc/unixODBC, I got a different error.  Oddly, it appears to want the 
>odbcinst.ini in /etc/ rather than /etc/unixODBC.
>After adding /opt/IBM/informix/lib/esql to ld.so.conf, the error is now:
>[IM009][unixODBC][Informix][Informix ODBC Driver]Unable to load 
>translation shared library (DLL).
>[ISQL]ERROR: Could not SQLConnect
>My odbc.ini file contains the line 
>"TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so" and the permission 
>of the file are "755 informix informix".
>I get the same error if I remove the TRANSLATIONDLL line from the odbc.ini 
>Don Arnett
>U.S. Courts - District of Nebraska
>don_arnett at ned.uscourts.gov
Try a

ldd /opt/IBM/informix/lib/esql/igo4a304.so

to see if there is any reason why its failing.

Also try using strace to see what odbc.ini is being read after the 
driver is loaded.

Did you export ODBCINI after setting it?

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list