Problems connecting to informix DB from linux

Submitted by chesterb on Mon, 2011-02-14 14:36

Ask Spokey

hi, can anyone help with this problem....I have been trying (in vain) to connect to an informix db from my linux box, here is what I have done so far...

Installed the IBM clientsdk.3.50.UC8DE...configured php with informix support (PDO)....set my environment vars to point to...

putenv("INFORMIXDIR=/opt/IBM/informix");
putenv("ODBCINI=/opt/IBM/informix/etc/odbc.ini");
putenv("INFORMIXSERVER=0629ti4061");
putenv("LDPATH=/opt/IBM/informix/lib:/opt/IBM/informix/lib/esql:/opt/IBM/informix/lib/cli:/opt/IBM/informix/lib/client");

        try
        {
            $db = new PDO("informix:DSN=CMSdrv", "", "");
        }

        catch (PDOException $e)
        {
            echo $e->getMessage();
        }

My odbc.ini is

[ODBC Data Sources]
Infdrv1=IBM INFORMIX ODBC DRIVER
Infdrv2=IBM INFORMIX ODBC DRIVER
CMSdrv=INFORMIX DRIVER
[CMSdrv]
Driver=/usr/lib/iclis09b.so
Description=CMS DATABASE
Driver=CMSdrv
Port=5000
LogonID=gateway
pwd=******
Servername=0629ti4061
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so

And odbcinst.ini is

[ODBC Drivers]
IBM INFORMIX ODBC DRIVER=Installed
[IBM INFORMIX ODBC DRIVER]
Driver=/usr/lib/iclit09b.so
Setup=/usr/lib/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
[INFORMIX DRIVER]
Driver=/usr/lib/iclit09b.so
Setup=/usr/lib/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y