Welcome to WebmasterWorld Guest from 54.145.166.96

Forum Moderators: open

Message Too Old, No Replies

mySQL with W2003

still won't connect.

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

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



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 Sep 9, 2005 (gmt 0)

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



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.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month