Topic
  • 1 reply
  • Latest Post - ‏2006-03-22T11:25:14Z by SystemAdmin
SystemAdmin
SystemAdmin
1143 Posts

Pinned topic Problem with configuring ODBC in Linux

‏2006-02-16T08:05:14Z |
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

$HOME/.odbcinst.ini :

;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbcinst.ini
;
;---------------------------------------------------------------------------
\n
ODBC Drivers
IBM INFORMIX ODBC DRIVER=Installed
\n
IBM INFORMIX ODBC DRIVER
Driver=/opt/informix/lib/cli/iclis09b.so
Setup=/opt/informix/lib/cli/iclis09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y

$HOME/.odbc.ini :

tivoli1
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
Updated on 2006-03-22T11:25:14Z at 2006-03-22T11:25:14Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: Problem with configuring ODBC in Linux

    ‏2006-03-22T11:25:14Z  
    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:
    LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/cli:$INFORMIXDIR/lib/c++

    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.

    Comments:

    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
    http://www.unixodbc.org
    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://www-306.ibm.com/software/data/informix/downloads.html
    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:
    http://www-128.ibm.com/developerworks/kickstart/?S_TACT=105AGX01&S_CMP=SIMPLE