Welcome to WebmasterWorld Guest from 54.167.86.211

Forum Moderators: open

Message Too Old, No Replies

mySQL with W2003

still won't connect.

     
8:21 pm on Sep 9, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


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.

9:16 pm on Sept 9, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members