Posted by scottauge@gmail.com on 11/03/06 11:27

MDB2 doesn't seem to work.

I have had the same problems with it on PostgreSQL. (See an earlier
message.)

I continue to database abstract with pear's DB package.

Swincher wrote:
> Hey - - -- --- --- - -- -
>
> Any data folks out there? I have started investigating the use of MDB2
> for a data object. So far, it is winning the struggle...
>
> I am just trying to connect to a database and run a "select * from
> <table>" query.
>
> The language is below, taken essentially from the docs. the language
> does, well, nothing. it neither throws an error nor echo's "Worked."
> The script just stops at the "connect() line. Even a simple ECHO
> statement fails after that line. I shouldn't need UN/PW, but I have
> tried it both ways.
>
> Anybody give me a clue what or how to check what is going on?
>
> (environment: PHP 5.1, MySQL 5.0, W2K Server and W2K client)
>
> Thanks ----- - -Ken
> --------------------------------------------------------------------------------------
> require_once 'MDB2.php';
>
> $dsn = array(
> 'phptype' => 'mysql',
> 'hostspec' => 'localhost',
> 'database' => 'mydatabase',
> );
>
> $options = array(
> 'debug' => 0,
> 'portability' => MDB2_PORTABILITY_ALL,
> );
>
> $mdb2 =& MDB2::connect($dsn, $options);
> echo is_null($mdb2)." = Null <br>";
> if (PEAR::isError($mdb2)) {
> die($mdb2->getMessage());
> } else {
> echo "Worked<br>";
> }
> *****************************************************************

[Back to original message]