Re: php + infomix (ifx_ or pdo_informix)
Fernando Ortiz wrote: > Hi, > Hi Fernando, > 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. > OK. You're having the same problem I have. The only solution I found so far is to rewrite the code to make use the new PDO_INFORMIX extension. > 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) > ) > did you read the manual? http://de.php.net/manual/de/ref.pdo-informix.php There's also a good explanation here: (Linux) http://www.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/ and here: (Windows) http://www.ibm.com/developerworks/db2/library/techarticle/dm-0607bombardier/ > Where can I report bugs to PDO_INFORMIX? > check out this one: http://pecl.php.net/bugs/report.php?package=PDO_INFORMIX However I'm not fully satisfied with the support on this package. It seems that PDO_INFORMIX, although it has more downloads than the PDO_IBM package, is not really maintained. I reported a bug about one month ago and got a feedback that a solution is on the way. However I don't see any progress. And there seems to be a problem when trying to connect to a 7.31 instance on a SCO Unixware machine. I rewrote my entire code to make use of the PDO_INFORMIX extension and now I'm stuck because it works fine with a IDS 10 test instance but our main database resides on an older IDS 7.31 and all I get is this error string: SQLSTATE[]: <<Unknown error>>: 0 (SQLParamData[0] at /usr/local/src/php-5.2.0/ext/pdo_informix/informix_statement.c:783) Running the same statement against an IDS 10 instance just works fine. > TIA > Regards -- Roland Wintgen (Systemadministrator) rw@evg.de Tel. +49 2166 5508-23 Fax +49 2166 5508-20 EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co. KG Trompeterallee 244-246, 41189 M'nchengladbach Tel. +49 2166 5508-0, Fax +49 2166 5508-90 www.evg.de info@evg.de Sitz: M'nchengladbach, Rechtsform: KG, MG HRA 9281 Komplement'r: Martens & Hamacher Verwaltungsgesellschaft mbH Sitz: M'nchengladbach, MG HRB 2523 Gesch'ftsf'hrer: J'rg R. Martens, Axel Hamacher, Dirk Martens-Ritz
Hi Roland, On Aug 20, 5:44 am, Roland Wintgen <r...@evg.de> wrote: > OK. You're having the same problem I have. The only solution I found so > far is to rewrite the code to make use the new PDO_INFORMIX extension. > > Found your bug report in http://pecl.php.net/bugs/bug.php?id=11566 dated July 8, I hope the ptach opendev is testing get released sonn. > > did you read the manual?http://de.php.net/manual/de/ref.pdo-informix.php Yes, the full 6 paragrpahs of the manual, ;) > > There's also a good explanation here: > (Linux)http://www.ibm.com/developerworks/db2/library/techarticle/dm-0606bomb... > and here: > (Windows)http://www.ibm.com/developerworks/db2/library/techarticle/dm-0607bomb... For installing is fine, but already done. > > > Where can I report bugs to PDO_INFORMIX? > > check out this one:http://pecl.php.net/bugs/report.php?package=PDO_INFORMIX > > However I'm not fully satisfied with the support on this package. It > seems that PDO_INFORMIX, although it has more downloads than the PDO_IBM > package, is not really maintained. I reported a bug about one month ago > and got a feedback that a solution is on the way. However I don't see > any progress. I'try to 'port' the ifx_ extension from PHP 5.1 to PHP 5.2, it's old but at least working. Thank you
Hi Roland, I am the lead of the team that owns the PDO_INFORMIX driver. I want to assure you that the PDO_INFORMIX driver is being actively maintained by IBM but as the postings on http://pecl.php.net/bugs/bug.php?id=11566 show, the problem is not with the PDO_INFORMIX driver but with the PDO layer. We have been actively trying to get Zend to release an update to PDO to fix this problem. I am hoping that I will know more from Zend in the next few days and I will contact you personally regarding this issue. Also, I want you to know that starting with the IDS Cheetah release (11.10), there is a new PDO driver (PDO_IBM) which will also work with IDS. This driver uses the DRDA connectivity feature which was added in IDS 11.10. Also, if you want to get in touch with my team directly, you can send a mail to opendev@us.ibm.com. Thanks for your patience and your inputs. They are invaluable in improving the quality and functionality of the IBM PHP drivers. Regards, -Manas On Aug 20, 5:44 am, Roland Wintgen <r...@evg.de> wrote: > Fernando Ortiz wrote: > > Hi, > > Hi Fernando, > > > 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 > > isPDO_INFORMIX. > > OK. You're having the same problem I have. The only solution I found so > far is to rewrite the code to make use the newPDO_INFORMIXextension. > > > > > Where can I find the old ifx_ extension? is it still recommended/ > > supported? > > > I also tried thePDO_INFORMIXextension 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) > > ) > > did you read the manual?http://de.php.net/manual/de/ref.pdo-informix.php > > There's also a good explanation here: > (Linux)http://www.ibm.com/developerworks/db2/library/techarticle/dm-0606bomb... > and here: > (Windows)http://www.ibm.com/developerworks/db2/library/techarticle/dm-0607bomb... > > > Where can I report bugs toPDO_INFORMIX? > > check out this one:http://pecl.php.net/bugs/report.php?package=PDO_INFORMIX > > However I'm not fully satisfied with the support on this package. It > seems thatPDO_INFORMIX, although it has more downloads than the PDO_IBM > package, is not really maintained. I reported a bug about one month ago > and got a feedback that a solution is on the way. However I don't see > any progress. > > And there seems to be a problem when trying to connect to a 7.31 > instance on a SCO Unixware machine. I rewrote my entire code to make use > of thePDO_INFORMIXextension and now I'm stuck because it works fine > with a IDS 10 test instance but our main database resides on an older > IDS 7.31 and all I get is this error string: > SQLSTATE[]: <<Unknown error>>: 0 (SQLParamData[0] at > /usr/local/src/php-5.2.0/ext/pdo_informix/informix_statement.c:783) > Running the same statement against an IDS 10 instance just works fine. > > > TIA > > Regards > > -- > Roland Wintgen (Systemadministrator) > > r...@evg.de > Tel. +49 2166 5508-23 > Fax +49 2166 5508-20 > > EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co. KG > Trompeterallee 244-246, 41189 Mönchengladbach > Tel. +49 2166 5508-0, Fax +49 2166 5508-90www.evg.dei...@evg.de > > Sitz: Mönchengladbach, Rechtsform: KG, MG HRA 9281 > Komplementär: Martens & Hamacher Verwaltungsgesellschaft mbH > Sitz: Mönchengladbach, MG HRB 2523 > Geschäftsführer: Jörg R. Martens, Axel Hamacher, Dirk Martens-Ritz
Manas D wrote: > Hi Roland, Hi Manas, > I am the lead of the team that owns the PDO_INFORMIX driver. I want > to assure you that the PDO_INFORMIX driver is being actively > maintained by IBM but as the postings on http://pecl.php.net/bugs/bug.php?id=11566 > show, the problem is not with the PDO_INFORMIX driver but with the PDO > layer. We have been actively trying to get Zend to release an update > to PDO to fix this problem. I am hoping that I will know more from > Zend in the next few days and I will contact you personally regarding > this issue. OK, I see. Thank you for your clarification. > Also, I want you to know that starting with the IDS Cheetah release > (11.10), there is a new PDO driver (PDO_IBM) which will also work with > IDS. This driver uses the DRDA connectivity feature which was added in > IDS 11.10. Also, if you want to get in touch with my team directly, > you can send a mail to opendev@us.ibm.com. > BTW, are you aware of any incompatibilities with older IDS versions using the latest available PDO_INFORMIX driver as described in my earlier posting? If you need an example, I could mail a code snippet to your team. > Thanks for your patience and your inputs. They are invaluable in > improving the quality and functionality of the IBM PHP drivers. > > Regards, > -Manas > > >> >> However I'm not fully satisfied with the support on this package. It >> seems thatPDO_INFORMIX, although it has more downloads than the PDO_IBM >> package, is not really maintained. I reported a bug about one month ago >> and got a feedback that a solution is on the way. However I don't see >> any progress. >> >> And there seems to be a problem when trying to connect to a 7.31 >> instance on a SCO Unixware machine. I rewrote my entire code to make use >> of thePDO_INFORMIXextension and now I'm stuck because it works fine >> with a IDS 10 test instance but our main database resides on an older >> IDS 7.31 and all I get is this error string: >> SQLSTATE[]: <<Unknown error>>: 0 (SQLParamData[0] at >> /usr/local/src/php-5.2.0/ext/pdo_informix/informix_statement.c:783) >> Running the same statement against an IDS 10 instance just works fine. >> >>> TIA Regards -- Roland Wintgen (Systemadministrator) rw@evg.de Tel. +49 2166 5508-23 Fax +49 2166 5508-20 EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co. KG Trompeterallee 244-246, 41189 M'nchengladbach Tel. +49 2166 5508-0, Fax +49 2166 5508-90 www.evg.de info@evg.de Sitz: M'nchengladbach, Rechtsform: KG, MG HRA 9281 Komplement'r: Martens & Hamacher Verwaltungsgesellschaft mbH Sitz: M'nchengladbach, MG HRB 2523 Gesch'ftsf'hrer: J'rg R. Martens, Axel Hamacher, Dirk Martens-Ritz
Hi Roland, That would be great. Please mail the code snippet to opendev@us.ibm.com Thanks, -Manas On Aug 21, 5:31 am, Roland Wintgen <r...@evg.de> wrote: > Manas D wrote: > > Hi Roland, > > Hi Manas, > > > I am the lead of the team that owns the PDO_INFORMIX driver. I want > > to assure you that the PDO_INFORMIX driver is being actively > > maintained by IBM but as the postings onhttp://pecl.php.net/bugs/bug.php?id=11566 > > show, the problem is not with the PDO_INFORMIX driver but with the PDO > > layer. We have been actively trying to get Zend to release an update > > to PDO to fix this problem. I am hoping that I will know more from > > Zend in the next few days and I will contact you personally regarding > > this issue. > > OK, I see. Thank you for your clarification. > > > Also, I want you to know that starting with the IDS Cheetah release > > (11.10), there is a new PDO driver (PDO_IBM) which will also work with > > IDS. This driver uses the DRDA connectivity feature which was added in > > IDS 11.10. Also, if you want to get in touch with my team directly, > > you can send a mail to open...@us.ibm.com. > > BTW, are you aware of any incompatibilities with older IDS versions > using the latest available PDO_INFORMIX driver as described in my > earlier posting? > If you need an example, I could mail a code snippet to your team. > > > > > Thanks for your patience and your inputs. They are invaluable in > > improving the quality and functionality of the IBM PHP drivers. > > > Regards, > > -Manas > > >> However I'm not fully satisfied with the support on this package. It > >> seems thatPDO_INFORMIX, although it has more downloads than the PDO_IBM > >> package, is not really maintained. I reported a bug about one month ago > >> and got a feedback that a solution is on the way. However I don't see > >> any progress. > > >> And there seems to be a problem when trying to connect to a 7.31 > >> instance on a SCO Unixware machine. I rewrote my entire code to make use > >> of thePDO_INFORMIXextension and now I'm stuck because it works fine > >> with a IDS 10 test instance but our main database resides on an older > >> IDS 7.31 and all I get is this error string: > >> SQLSTATE[]: <<Unknown error>>: 0 (SQLParamData[0] at > >> /usr/local/src/php-5.2.0/ext/pdo_informix/informix_statement.c:783) > >> Running the same statement against an IDS 10 instance just works fine. > > >>> TIA > > Regards > > -- > Roland Wintgen (Systemadministrator) > > r...@evg.de > Tel. +49 2166 5508-23 > Fax +49 2166 5508-20 > > EVG Elektro-Vertriebs-Gesellschaft Martens GmbH & Co. KG > Trompeterallee 244-246, 41189 Mönchengladbach > Tel. +49 2166 5508-0, Fax +49 2166 5508-90www.evg.dei...@evg.de > > Sitz: Mönchengladbach, Rechtsform: KG, MG HRA 9281 > Komplementär: Martens & Hamacher Verwaltungsgesellschaft mbH > Sitz: Mönchengladbach, MG HRB 2523 > Geschäftsführer: Jörg R. Martens, Axel Hamacher, Dirk Martens-Ritz