Hi,
I've recently upgraded to Vista Ultimate 32bit and I'm having problems with my database connections.
When I try to connect to a MySQL database using the connection string I used (and functioned) on IIS 5.1 in XP I get the following error.
error '80004005'
/newstest.asp, line 8
Line 8 being - rsNews.ActiveConnection = MM_connEdit_STRING
The include file I use is
Dim MM_connEdit_STRING
MM_connEdit_STRING = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=editable;UID=xxxx;PWD=xxxx;OPTION=3;"
I'm aware that this is a fairly common error and is almost certainly due to permissions but I have made the changes found at http://blogs.iis.net/bills/archive/2006/10/18/loadUserProfile-and-IIS7-_2D00_-understanding-temporary-directory-failures.aspx and they haven't resolved the issue.
However, if I create a DNS everything functions correctly and I can read from the database with no difficulty.
Now I'm pretty new at this and my knowledge is rather lacking but why would a DNS connection work and a Connection String fail when they both use the same ODBC driver?
Thanks in advance for any advice.