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

Connection String Giving issues

Connection String Giving issues

(OP)
I am sure an answer is out there somewhere.

We had to upgrade our server to MySql 5.5
Hey wonderful and great. My issue is now my connection strings will not work and I get the following error:

CODE

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/inc/connection.asp, line 8 

I am using MySql DB within a classic asp environment but I know this is not the problem.

My connection string is as follows:

CODE

<% 
Dim sConnection, objConn , objRS 

sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydbname; UID=tmyuserid;PASSWORD=mypassword; OPTION=3" 

Set Conn = Server.CreateObject("ADODB.Connection") 

Conn.Open(sConnection) 

%> 

I have tried to change the driver to 5.5 with no luck. I know the problem lies with the driver and the version of MySql.
I have tried over a dozen different strings but all give the same result.
Any Ideas?

RE: Connection String Giving issues

this does not look like a mysql issue.

however if it helps I always use a system DSN rather than 'dsnless' dsn. i find i avoid problems that way.

one other gotcha is that the mysql odbc driver is 32 bit only so to get access to it you will need to run the 32 bit odbc plugin. the default plugin that runs is 64 bit.

RE: Connection String Giving issues

(OP)
Thanks for the reply. I feel like a novice since I have found the issue.

First I needed to do this:

CODE

sConnection = "DRIVER={MySQL ODBC 5.2 Driver}; 

Then I needed to actually grant permissions on the odbc folder that contained the .dll file for the driver.

Doing both of these now gives me a good string and connection.

Thanks again!

RE: Connection String Giving issues

well found!

setting up a system or file DSN in the plugin avoids those issues. Just FYI,

RE: Connection String Giving issues

(OP)
I shall look into that. Thanks again!

RE: Connection String Giving issues

(OP)
Well I am back.

I had to move the VPS from godaddy to another. They just aren't used to dealing with windows servers I guess but anyway.

I am having issues again with the same error. The same fix I performed last time did not work this time.

I am not versed in DSN connections and would like to know if someone can steer me in the right direction.
What I don't know is.... the dsn is the same as a dsn nameserver?


RE: Connection String Giving issues

DSN nameserver???

Do you mean DNS nameserver


If so, they are both absolutely, totally. different things entirely.


DSN == Data Source Name

DNS == Domain Name System.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: Connection String Giving issues

(OP)
Why yes, I did get those confused.

It has been a long week.

So what exactly is the dsn then? just the database name?

RE: Connection String Giving issues

dsn is the tconnection to a database (literally: data source name). It is most often used by abstraction layers such as odbc.

please use the windows snap-in. it makes life so much easier.

but if the connection string itself does not work the most likely reason is that the drivers are not installed.

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