In Linux Client:
1. Install Informix CSDK
2. Edit sqlhosts
3. Configure ODBC
odbcinst.ini and odbc.ini from CSDK copy to $HOME/.odbcinst and .odbc.ini, and .odbc.ini was edit (LogonID, Database, Servername, pwd).
How to check connect to database over ODBC from Linux client ?
CSDK installed in /opt/informix
; IBM INFORMIX ODBC Sample File
; File: odbcinst.ini
IBM INFORMIX ODBC DRIVER=Installed
IBM INFORMIX ODBC DRIVER
Driver = /opt/informix/lib/cli/iclis09b.so
Description = IBM INFORMIX ODBC DRIVER
Database = ccm
LogonID = tivoli
pwd = tivolip660
Servername = t10_on
Trace = 1
TraceFile = /tmp/odbctrace.out
InstallDir = /opt/informix
Test odbc connection by command 'isql tivoli1' does not work:
ISQLERROR: Could not SQLConnect
Pinned topic Problem with configuring ODBC in Linux
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2006-03-22T11:25:14Z at 2006-03-22T11:25:14Z by SystemAdmin
SystemAdmin 110000D4XK1143 Posts
Re: Problem with configuring ODBC in Linux2006-03-22T11:25:14ZThis is the accepted answer. This is the accepted answer.Step 1: Copy the example odbcinst.ini and odbc.ini from the CSDK directory
$INFORMIXDIR/etc into the following directory :
for one user : $HOME/.odbcinst.ini and $HOME/.odbc.ini ( == User-DSN)
for all users: /etc/odbcinst.ini and /etc/odbc.ini ( == System DSN)
and setting Environment Variable needed ODBCINI=/etc/odbc.ini , etc
Step 2: You have to edit those files: ".odbc.ini"
for example change line "Driver=/extra/informix/lib/cli/iclit09b.so"
into Driver=/informix/lib/cli/iclit09b.so the installation directory
Warning: be carefull when editing ; enter the minimum first because
incorrect entries might stop the program work
Step 3: set Environment Variables (shared library path) for example Linux:
Warning: instead of LD_LIBRARY_PATH use LIBPATH on AIX, SHLIB_PATH on HP-UX
see the Informix Machine Notes (Release Notes); those told you what to do
Step 4:If you are not working with an ODBC Manager you can compile and run
the ODBC Demos which are delivered by Informix and can be found in
$INFORMIXDIR/demo/cli . If you have an C-Compiler installed on your machine
you only have to enter a make in that directory to compile all the sources
use for example "dbcreate.c" or "dbcreateW.c" (example for Wide ...)
Step 5: If your application is using an ODBC Manager you can use their
demos. If you wants to test your odbc configuration on a LINUX machine
you will find installed a UNIXODBC ODBC Manager so simply start one of
the programs: I suggest "isql" to see how to use it.
1) IBM Informix didn't deliver ODBC Manager any longer: 32 Bit SDK Versions
for Solaris and AIX had been delivred an Datadirect ODBC-Manager before.
But because of excellent freeware like the ODBC Manager UNIXODBC
Informix will not deliver that part of software any longer.
2) using unixODBC version 2.2.11-1 and SDK 2.90.UC4, you might receive the
ERROR: -11048 ; if that occurs you need a fix or you have to install an
older SDK Version
3) regarding the download of "Client SDK for Linux" using the URL:
http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxdl (Client SDK)
there are many products for Linux ; all new Linux Systems are build for
REDHAT ADV SVR Enterprise 3.0 but will work on new SuSE versions too.
a) Important is that it is certiied for glibc 2.3.x . Versions for Linux 2.4.xx
are certified for old glibc 2.2.x and can not be used on new Operation Systems.
b) look to the processor information in the download name too because
REDHAT ADV SVR Enterprise 3.0 RHEL 3 is ported for serveral processors now:
64 Bit have the extension "FCx" ; 32 Bit have the extension "UCx"
Intel x86 32-bit / RHEL 3 or SUSE SLES 9 (this is for new 32 Bit Intel AMD machines)
IBM zSeries 64-bit / RHEL 3 or SUSE SLES 9
POWER 64-bit / RHEL 3 or SUSE SLES 9
Itanium 64-bit / RHEL 3 or SUSE SLES 9
http://www-306.ibm.com/software/data/informix/linux/csdk.html LINUX Roadmap
c) did you know the Information at: