Has anyone had any luck getting PDO_IBM to work?
Posted in 2008
A user wanted to connect PHP's PDO_IBM driver to Informix for use with Zend Framework, complaining of a lack of examples or documentation. One reply pointed to the php.net PDO_INFORMIX page, but Fernando Nunes noted PDO_IBM is not PDO_INFORMIX and requires the DRDA listener to be configured, supplying links to an IBM developerWorks thread and Informix Infocenter pages on PHP and DRDA. The poster then set up DRDA and tried a PDO connection string, but hit a PDOException ("SQLSTATE=, SQLAllocHandle: 0"). The thread ends there, with no resolution recorded.
Topics: General Discussion
We havent and theres no examples or documentation to be found. Someone in this newsgroup claimed to have figured it out last month but didnt give any examples. We would like to use Informix with Zend Framework.
Kristof Benes said: > We havent and theres no examples or documentation to be found. Someone > in this newsgroup claimed to have figured it out last month but didnt > give any examples. We would like to use Informix with Zend Framework. Not being anywhere near an instance or anything, I can't comment in any detail, but what about this: http://pl2.php.net/manual/en/ref.pdo-informix.connection.php ? -- Bye now, Obnoxio http://obotheclown.blogspot.com/
Kristof Benes wrote: > We havent and theres no examples or documentation to be found. Someone > in this newsgroup claimed to have figured it out last month but didnt > give any examples. We would like to use Informix with Zend Framework. Try this info: http://www.ibm.com/developerworks/forums/thread.jspa?threadID=228754&tstart=0 http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.conn.doc/php.htm http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/ids_admin_0205.htm If you can't do it, try to tell us what you did and what you got... I think I never tried it, but it would be a very good reason to do so :) Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Obnoxio The Clown wrote: > Kristof Benes said: >> We havent and theres no examples or documentation to be found. Someone >> in this newsgroup claimed to have figured it out last month but didnt >> give any examples. We would like to use Informix with Zend Framework. > > Not being anywhere near an instance or anything, I can't comment in any > detail, but what about this: > http://pl2.php.net/manual/en/ref.pdo-informix.connection.php ? > PDO_IBM != PDO_INFORMIX For PDO_IBM you need to configure DRDA... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Fernando Nunes wrote: > Kristof Benes wrote: >> We havent and theres no examples or documentation to be found. >> Someone in this newsgroup claimed to have figured it out last month >> but didnt give any examples. We would like to use Informix with Zend >> Framework. > > Try this info: > > http://www.ibm.com/developerworks/forums/thread.jspa?threadID=228754&tstart=0 > > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.conn.doc/php.htm > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/ids_admin_0205.htm > > > If you can't do it, try to tell us what you did and what you got... > I think I never tried it, but it would be a very good reason to do so :) > > Regards. > Thank you Fernando. I will give it a look tomorrow.
Fernando Nunes wrote: > Kristof Benes wrote: >> We havent and theres no examples or documentation to be found. >> Someone in this newsgroup claimed to have figured it out last month >> but didnt give any examples. We would like to use Informix with Zend >> Framework. > > Try this info: > > http://www.ibm.com/developerworks/forums/thread.jspa?threadID=228754&tstart=0 > > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.conn.doc/php.htm > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/ids_admin_0205.htm > > > If you can't do it, try to tell us what you did and what you got... > I think I never tried it, but it would be a very good reason to do so :) > > Regards. > Okay, so I've got DRDA installed on the remote machine, and I tried this (changed the ip address and password): $cn = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=fds_xdev;HOSTNAME=123.456.789.01;PORT=1538;PROTOCOL=TCPIP;","chris","******"); And I get: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE=, SQLAllocHandle: 0 ' in /home/chris/test.php:3