Oninit cdi / Archive
Talk to an expert →

php + infomix (ifx_ or pdo_informix)

Posted in 2007

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

Fernando Ortiz — — source: Usenet: comp.databases.informix

Hi, I've using PHP_Informix using the ifx_ extension, but while trying to upgrade PHP to 5.2.x I found this Note: This extension has been moved to the » PECL repository and is no longer bundled with PHP as of PHP 5.2.1. So I tried to install from PECL with no luck, the only extension there is PDO_INFORMIX. Where can I find the old ifx_ extension? is it still recommended/ supported? I also tried the PDO_INFORMIX extension and found this ugly error with a simple select from another database $sth = $conn->query("select count(*) from nomi:empljava"); print_r( $conn->errorInfo()); ( [0] => 42000 [1] => -201 [2] => [Informix][Informix ODBC Driver][Informix]A syntax error has occurred . (SQLPrepare[4294967095] at /root/tmp/PDO_INFORMIX-1.1.0/ informix_driver.c:131) ) Where can I report bugs to PDO_INFORMIX? TIA

↪ replying to Fernando Ortiz
Gerardo Santana — — source: Usenet: comp.databases.informix

On Aug 17, 4:31 pm, Fernando Ortiz <fernando.ortiz@gmail.com> wrote: > Hi, > > I've using PHP_Informix using the ifx_ extension, but while trying to > upgrade PHP to 5.2.x I found this > > Note: This extension has been moved to the » PECL repository and is > no longer bundled with PHP as of PHP 5.2.1. > > So I tried to install from PECL with no luck, the only extension there > is PDO_INFORMIX. > > Where can I find the old ifx_ extension? is it still recommended/ > supported? > > I also tried the PDO_INFORMIX extension and found this ugly error with > a simple select from another database > > $sth = $conn->query("select count(*) from nomi:empljava"); > print_r( $conn->errorInfo()); > ( > [0] => 42000 > [1] => -201 > [2] => [Informix][Informix ODBC Driver][Informix]A syntax error > has occurred > . (SQLPrepare[4294967095] at /root/tmp/PDO_INFORMIX-1.1.0/ > informix_driver.c:131) > ) > > Where can I report bugs to PDO_INFORMIX? > > TIA I'm not familiar with PDO_Informix (I left PHP behind a long time ago), but the error message suggests that the underlying ODBC driver doesn't not support the database:table syntax and then triggers a syntax error. I suggest to workaround it, establishing another connection to nomi.

Related threads