Fwd: PEAR and MDB2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



but the problem is before:
$mdb2 =& MDB2::connect($dsn);
                       if (PEAR::isError($mdb2))
                       {

die($mdb2->getMessage()."<br><br>".$db2->getUserinfo());
                       }

generate a :
MDB2 Error: not found connect: [Error message: extension pgsql is not
compiled into PHP]
** pgsql(pgsql)://login:xxx@localhost:5432/mydbname

how is it possible ?
when i control the php.ini and phpinfo() i see that pgsql is install and
activated.

So, what did i miss ?

Al.


On 11/12/06, Roman Neuhauser <neuhauser@xxxxxxxxxx> wrote:

# raf.news@xxxxxxxxx / 2006-11-12 09:46:34 +0100:
> so when i have this code :
> $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());
>    }
>
>    $res = $db2->exec($query);
>    if (PEAR::isError($res))
>    {
>        die("Error connection : ".$res->getMessage());
>    }
>
> i get this error ==> "Error connection : MDB2 Error: unknown error"
(from
> $res control)

http://pear.php.net/manual/en/package.database.mdb2.intro-query.php
says:

    exec() should be used for manipulation queries.

IOW, you should use query() for SELECTS, exec() for other statements.
Perhaps that's your problem?

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991





--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux