note 84614 added to ref.pdo-informix

Solved the issue with PHP 5.2.4 and others. The embedded PDO in php since 5.1+ is INCOMPATIBLE with the latest PDO_MYSQL and PDO_INFORMIX, etc. I just spent 2 days working on this. This solution works on numerous versions of Linux I've tried as well as SunOS and HPUX. The basic issue, getting this message when running PHP with PDO and trying to get PDO_INFORMIX working, but having a version conflict: "PHP Fatal error: PDO: driver informix requires PDO API version 20060409; this is PDO version 20060511 in Unknown on line 0" The "embedded" PDO that is within PHP since version 5.1 CONFLICTS with the PDO the PEAR/PECL modules are expecting. 1) Rebuild PHP with no pdo (--disable-pdo) (and you can't have any stuff like --with-mysql-pdo, either) 2) Then use PEAR/PECL to install PDO: pear install pdo 3) then use PEAR/PECL to install PDO_INFORMIX: pear install --alldeps pdo_informix 4) make sure your php.ini extensions_dir points to the directory where these are placed 5) then add these references to php.ini: extensions=pdo.so extensions=pdo_informix.so extensions=pdo_mysql.so (etc.) 6) run php -v now and you should not see any errors. 7) run "pear list" and "pecl list" to see the installed modules 8) run php -i |egrep "pdo|PDO" to see: php -i |egrep "pdo|PDO" Configure Command => './configure' '--disable-pdo' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-openssl=/usr' '--enable-force-cgi-redirect' '--with-gd' '--with-jpeg-dir=/usr/lib' '--with-zlib' '--enable-bcmath' '--enable-mbstring=all' '--with-curl' PDO PDO support => enabled PDO drivers => mysql, informix pdo_informix pdo_informix support => enabled pdo_mysql PDO Driver for MySQL, client library version => 5.0.51a I would have tried the embedded PDO and then also --with-informix-pdo=shared but as an earlier post here showed, the --with-informix... is unknown. Please correct my mistake if I am mistyping it. GOOD LUCK! David ---- Server IP: 64.71.164.2 Probable Submitter: 64.31.153.69 ---- Manual Page -- http://www.php.net/manual/en/ref.pdo-informix.php Edit -- https://master.php.net/note/edit/84614 Del: integrated -- https://master.php.net/note/delete/84614/integrated Del: useless -- https://master.php.net/note/delete/84614/useless Del: bad code -- https://master.php.net/note/delete/84614/bad+code Del: spam -- https://master.php.net/note/delete/84614/spam Del: non-english -- https://master.php.net/note/delete/84614/non-english Del: in docs -- https://master.php.net/note/delete/84614/in+docs Del: other reasons-- https://master.php.net/note/delete/84614 Reject -- https://master.php.net/note/reject/84614 Search -- https://master.php.net/manage/user-notes.php