Re: Trying to connext to MySQL with PEAR

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

 



In my (very) limited experience with PEAR::DB, I've found that
getMessage() doesn't give very verbose error messages :).

So if I'm really having a problem, I do all 4 of these:

echo 'Standard Message: ' . $db->getMessage() . "<br>\n";
echo 'Standard Code: ' . $db->getCode() . "<br>\n";
echo 'DBMS/User Message: ' . $db->getUserInfo() . "<br>\n";
echo 'DBMS/Debug Message: ' . $db->getDebugInfo() . "<br>\n";


At least for me, this gives me a lot more useful information (DB
1.6.8, but PHP 5.0.3).  Hope this helps.

On Thu, 6 Jan 2005 11:42:03 -0500, Jason Davis <cephme@xxxxxxxxx> wrote:
> Pear DB version is 1.6.8
> 
> 
> "Jason Davis" <cephme@xxxxxxxxx> wrote in message
> news:20050106162049.40208.qmail@xxxxxxxxxxxxxxx
> > MySQL 4.1
> > PHP 4.3.10
> > PEAR 0.5.0 (I think, not sure how to test that)
> >
> > On two different boxes
> > one is an XP Pro box
> > one is an Win2K Pro Box
> >
> > both running IIS
> >
> > "Richard Hutchins" <Richard.Hutchins@xxxxxxxxxxxxxx> wrote in message
> > news:1EA7D3AE70ACD511BE6D006097A78C1E0588813B@xxxxxxxxxxx
> > > What version of PHP?
> > > What version of MySQL?
> > >
> > > -----Original Message-----
> > > From: Jason Davis [mailto:cephme@xxxxxxxxx]
> > > Sent: Thursday, January 06, 2005 10:42 AM
> > > To: php-db@xxxxxxxxxxxxx
> > > Subject:  Trying to connext to MySQL with PEAR
> > >
> > >
> > > Hi all I am new to PHP and am trying to connect to mysql for the first
> > time.
> > > I get activity on the mysql monitor when I run it, but get the following
> > > error.
> > >
> > > DB Error: connect failed
> > >
> > > The lines of code are:
> > > require_once( "DB.php" );
> > > $dsn = "mysql://".DB_USER.":".DB_PASS."@".DB_SERVER."/".DB_NAME;
> > > echo $dsn;
> > > $isPersistant = TRUE;
> > > $db = DB::connect($dsn, $isPersistant);
> > >
> > > if ( DB::isError( $db ) ) {
> > >     die ($db->getMessage());
> > > }
> > >
> > > The constants are properly defined and passing through to this page
> > (checked
> > > with echo), the database is created, the user has an account, and the
> > > account has rights to do all funcitons on the db. Any thoughts on what
> > might
> > > be wrong?
> > >
> > >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux