homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

mySQL with W2003
still won't connect.

 8:21 pm on Sep 9, 2005 (gmt 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?




 9:16 pm on Sep 9, 2005 (gmt 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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved