[pmwiki-users] Database Standard and ADOdb

[Ben Stallings]

SMETS Stephane BKS-IT wrote:
> I try to use dataquery cookbook with adodb.
> 
> I receive this error :
> 
> *Warning*: mysql_connect() [_function.mysql-connect_ 
> <http://phoenix-dev/WikiFields/synoptix/function.mysql-connect>]: Access 
> denied for user 'ODBC'@'localhost' (using password: NO) in* 
> D:\Phoenix\webroot\wiki\cookbook\adodb\drivers\adodb-mysql.inc.php* on 
> line* 358*

 From the looks of this error, it looks like your username is ODBC. 
That's unusual... is it correct?  Could you copy your configuration of 
the $Databases variable, with your password obscured with ****s, so that 
I can see what you're working with?

> We use PHP 5.20 and the Mysql is 5.1.14 : is adodb compatible with the 
> new Mysql client used in these release?

Honestly, I'm not sure.  I think the latest verison of MySQL I've tested 
it with is 5.0.27 (with PHP 5.21).  The ADOdb software has not been 
revised since August 2006, so there is a "definite possibility," as we 
say, that it may not be compatible with MySQL 5.1, but I would be surprised.

When you say you checked that the login info is correct, does that mean 
that you've used the same login info with another PHP program on the 
same server, or did you just check that it's *theoretically* correct?

I see you're using Windows... is your Web server Apache, or IIS?  I have 
had no luck with IIS, personally.

> Other question : there is no ODBC driver for Mysql installed.  I hope it 
> is not needed?

That's right, it is not needed.

Best of luck!  --Ben