PDO_IBM and IDS Cheetah on Linux   

Hi,

We have Informix IDS Cheetah installed on an AIX server, and would like to use Zend Framework to connect to it to develop an application. Our web server is running RedHat Enterprise, we are running a fairly new version of apache 2, and our php is compiled on site (not Zend Core). We have the DB2 client and CSDK installed and have sucessfully used PDO_INFORMIX. Our PHP version is:

PHP 5.2.5 (cli) (built: Oct 14 2008 14:35:12)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Debugger v5.2.12, Copyright (c) 1999-2007, by Zend Technologies

When we try to make a connection to the database using a fairly simple example:

$cn = new PDO("ibm:DATABASE=fds_xdev;HOSTNAME=eagle;PORT=1538;","chris","*******"); // password changed to protect the innocent

we get:

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE=, SQLAllocHandle: 0 ' in ...

eagle is the box with Cheetah running on it, and 1538 is the DRDA alias port number.

Documentation and especially examples seem almost impossible to come by, and the above error doesnt really help any. Does anyone have any pointers or suggestions on what to look at, what to do, etc... We really dont want to go to MySQL since we've been an Informix customer for almost 20 years.