Problems connecting to informix DB from linux
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
- Login to post comments
- 9371 reads
-
- Email this page
- Printer-friendly version
- Send by email
- PDF version


















Are you sure sqlhosts record
Are you sure sqlhosts record is:
0629ti4061 my.ip.address 5000
because you did not enter second field "onsoctcp"
HTH