INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Cannot connect to MySQL - Data source name not found and no default driver specified

Cannot connect to MySQL - Data source name not found and no default driver specified

Cannot connect to MySQL - Data source name not found and no default driver specified

(OP)
I just set up a Windows 2003 web server. This is a 32bit version of Windows. I've installed the latest version of MySql since I could not find my older version. I've installed the 5.2.5 odbc drivers. In my asp application this is my connection string:

strConn = "Driver = {MySQL ODBC 5.2 Driver}; Server=; Database=xxxxxxxxx; uid=xxxxx; pwd=xxxxxx; "
set objConn = server.CreateObject("ADODB.Connection")
objConn.Open strConn

The error returned is: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I've tried 5.2a, 5.2w, 5.2.5... I cannot figure out how to get this working. It works fine on my previous server, but this is driving me insane.

Thanks,
MN

Michael Netherton
Responder Public Safety Equipment
www.ResponderPSE.com

RE: Cannot connect to MySQL - Data source name not found and no default driver specified

I suppose your problem is this:

CODE

Server=; 
You have not specified a server.
Try instead:

CODE

Server=localhost; 

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

RE: Cannot connect to MySQL - Data source name not found and no default driver specified

(OP)
MIS, yes, I had tried that as well. I finally just gave up and installed the 3.5.1 drivers and everything works fine. The 5.2.5 drivers are just a major PITA !

Thanks,
MN

Michael Netherton
Responder Public Safety Equipment
www.ResponderPSE.com

RE: Cannot connect to MySQL - Data source name not found and no default driver specified

Start/Admin Tools/Data Sources

Check the names given to the datasources. Is MySQL there. If it isn't, it is not going to pick it up, whatever you do. If it is, what is it called? Is it different from what you're calling it?

If it is not there, you may have to add it. Adding data sources

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close