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

And sqlhost is

0629ti4061 my.ip.address 5000

And the error message I get is

SQLSTATE=HY000, SQLDriverConnect: -1210899976 [Informix][Informix ODBC Driver]General error.

This is literally driving me insane

    Write a Reply...