Data source name not found error

[Gatorajc]

I was not sure where to post this, to get the best answer, so some of you may have seen this post in the IIS forum.

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

 

[Tinso]

I am very much of a newbie wrt MYSQL. I have justed started playing around with MYSQL and a localhost website. I came across the same problem.. I had defined the DSN as 'User' and it tested ok but would not connect via the ASP web page. ("Data source name not found&quot As a desperation move I setup another ODBC DSN as 'system'
and it worked ? ? ? ? ?
luck beats skill !!!