homepage Welcome to WebmasterWorld Guest from 54.226.180.223
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.
txbakers




msg:1578546
 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?

Thanks.

 

txbakers




msg:1578547
 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