MDB2 and PostgreSQL
| From: | Alain Roger | 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