MDB2 and PostgreSQL

From: Date: Sun, 12 Nov 2006 17:40:59 +0000
Subject: MDB2 and PostgreSQL
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-25786@lists.php.net to get a copy of this message
Hi, I'm still working around my issue with MDB2 and MDB2_Driver_postgres global $dsn;
                       $options = array('debug'       => 2,
                                           'portability' =>
MDB2_PORTABILITY_ALL,
                                       );
                       $query = 'SELECT * from sp_u_001(\'all\')';
                       $db2 = & new MDB2_Driver_pgsql();
                       $db2->connect($dsn);
                       if (PEAR::isError($db2))
                       {
                           die("Error connection :
".$db2->getMessage()."<br><br>".$res->getUserinfo());
                      }
                      //$res =& $db2->query('SELECT * FROM articles');
                       $res = $db2->exec($query);
                       if (PEAR::isError($res))
                       {
                           die("Error connection :
".$res->getMessage()."<br><br>".$res->getUserinfo());
                       }
it does not matter, query or exec functions produce the same error message :
Error connection : MDB2 Error: not found         connect: [Error message:
extension pgsql is not compiled into PHP] where could be the problem ? pgsql is install via PHP.ini and works well if i do not use PEAR packages. thanks a lot for help, -- Alain ------------------------------------ Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5

« previous php.pear.general (#25786) next »