mySQL with W2003

still won't connect.

[txbakers]

Still trying to connect to mySQL on my W2003 box using the myODBC connector (3.51).

The ODBC screen shows a successful connection when I test.

The mySQL-Front connects without a problem.

But the Connection string I'm using for ASP throws an error:
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)

Here is the connection string:
var connStr ="Driver={MySQL ODBC 3.51 Driver};server=localhost;Database=charms;Option=1,user=#*$!xxx password=xxxxxx";

The username and password are good, they work in the other programs, but not the query string.

Is there something ELSE I have to allow in W2003 to allow this?

Thanks.

[txbakers]

Seek and Ye Shall Find when thy consultest the Oracle of All Knowledge - GOOGLE.

It was a different syntax than on 2000:

"Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=charms;UID=123456;PWD=123456";

darn syntax.