Last updated: Fri, 22 Aug 2008

Fonctions Informix (PDO_INFORMIX)

Introduction

PDO_INFORMIX est un pilote qui implémente l'interface de PHP Data Objects (PDO) pour autoriser l'accès à PHP aux bases de données Informix.

Installation

Pour compiler l'extension PDO_INFORMIX, le SDK Client Informix 2.81 UC1 ou supérieur doit être installé sur le même système que PHP. Le SDK Client Informix est disponible sur le » Site de Support IBM Informix.

PDO_INFORMIX est une extension » PECL, alors suivez les instructions dans Installation d'extensions PECL pour installer l'extension PDO_INFORMIX. Écrivez la commande configure pour pointer au chemin de vos fichiers d'en-têtes SDK Client Informix ainsi que les bibliothèques comme suit :

   bash$ ./configure --with-pdo-informix=/path/to/SDK[,shared]

La commande configure utilise par défaut la variable d'environnement INFORMIXDIR.

Curseurs flottants

PDO_INFORMIX supporte les curseurs flottants; cependant, ils ne sont pas activés par défaut. Pour activer le support des curseurs flottants, vous devez soit fixer ENABLESCROLLABLECURSORS=1 dans les configurations de la connexion ODBC correspondante dans odbc.ini ou passer la clause EnableScrollableCursors=1 dans la chaîne de caractères de connexion DSN.

Sommaire

PDO_INFORMIX DSN — Connexion aux bases de données Informix

PDO_INFORMIX DSN

PDO_IBM DSN

Last updated: Fri, 22 Aug 2008

add a note User Contributed Notes
Informix (PDO)

dbeecher at tekops dot com
22-Jul-2008 04:21


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

alan dot acosta at gps dot com dot co
20-Sep-2007 01:01


Take care, with php-5.2.4 --with-pdo-informix=shared,/home/informix

 doesn't work, just says: 

Notice: Following unknown configure options were used:

--with-pdo-informix=shared,/home/informix

jgp at iiug dot org
24-Mar-2006 04:27


IIUG (International Informix Users Group) has made the Windows driver available on its site (wwww.iiug.org), as it is not included in v5.1.2.



hih

add a note

PDO_INFORMIX DSN

PDO_IBM DSN

Last updated: Fri, 22 Aug 2008