RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-07 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 21:10, Norland, Martin wrote: -Original Message- From: Ford, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 1:13 PM Subject: RE:

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Hutchins, Richard
What version of PHP? What version of MySQL? -Original Message- From: Jason Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 10:42 AM To: php-db@lists.php.net Subject: [PHP-DB] Trying to connext to MySQL with PEAR Hi all I am new to PHP and am trying to connect to mysql

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Wong
On Thursday 06 January 2005 23:41, Jason Davis wrote: Hi all I am new to PHP and am trying to connect to mysql for the first time. In that case I strongly suggest that you at least vaguely familiarise yourself with using the basic PHP-native mysql_*() functions first. Go through the examples

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
Pear DB version is 1.6.8 Jason Davis [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
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 [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What version of PHP? What version of MySQL? -Original

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread James Pancoast
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

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
Ok tried that and go this error message instead. Client does not support authentication protocol requested by server; consider upgrading MySQL client Going to MySQL site to try to figure out what this means/which other clients are available. Jason Davis Jason Wong [EMAIL PROTECTED] wrote in

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
This helped a LOT! With that info I was able to figure out that I need to do this. http://dev.mysql.com/doc/mysql/en/Old_client.html Thanks everyone, Jason Davis Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Thursday 06 January 2005 23:41, Jason Davis wrote: Hi all

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 16:39, Jochem Maas wrote: Hutchins, Richard wrote: echo $dsn; $isPersistant = TRUE; doesn't effect the code but 'Persistant' is spelled 'Persistent' Oh

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Wong
On Friday 07 January 2005 03:12, Ford, Mike wrote: Oh dear, as a fully-paid-up pedant, I'm afriad I can't resist this one: I'm afraid it's afraid ... :-) Doesn't affect the answer, but this occurrence of 'effect' should be 'affect'. ;) Yeah and it annoys me too when people mix up you're and

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Norland, Martin
-Original Message- From: Ford, Mike [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 1:13 PM Subject: RE: [PHP-DB] Trying to connext to MySQL with PEAR [snip] Oh dear, as a fully-paid-up pedant, I'm afriad I can't resist this one: Doesn't affect the answer, but this

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jochem Maas
Ford, Mike wrote: To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 16:39, Jochem Maas wrote: Hutchins, Richard wrote: echo $dsn; $isPersistant = TRUE; doesn't effect the code but 'Persistant' is spelled