Data source name not found

[Gatorajc]

Has anyone else has this problem.

I am trying to connect to a MySQL database. I set up the odbc connection and when I test the connnection it says "connection successful" but when I try the connection string. It says "Data source name not found".

Now I know it is not the odbc connection or the connection string because I can set up the same exact setup on another web server and it sees the database. So it has to do something with IIS, maybe the settings or directory location I don't know but the settings look the same on both servers.


AJ

 

[alan2624]

Were you ever able to figure out what the problem was. I am currently having the same situation.

Thanks

 

[TRACEYMARYLAND]

Ok one easy way to get the right string.

Go to your desktop right click create a txt file..

Then rename this as myfile.udl
Make sure that you do not get myfile.udl.txt

Then double click this....This will bring up the ODBC panel...configure as you normally do with an ODBC setting...

Then save...it.

Next go to file.....open it in Notepad copy the string into your .....page........

Or you then can just do this.
conn.Open "File Name=C:\MYDIRECTORY\myfile.udl"