perlwhite
asked on
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Hello,
Our scripts are getting timed out with this error-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log] Query execution was interrupted
This is since we changed our server/hosting environment. The application was running smoothly wihtout any issues. The application is in classic ASP.
I did some searching and found this-
http://www.a2zmenu.com/Blogs/Miscellaneous/Microsoft-OLE-DB-Provider-for-ODBC-Drivers-error-80004005.aspx#
I believe, this has to be done by the hosting company. What is your take? Do you have any suggestions?
Our scripts are getting timed out with this error-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]
This is since we changed our server/hosting environment. The application was running smoothly wihtout any issues. The application is in classic ASP.
I did some searching and found this-
http://www.a2zmenu.com/Blogs/Miscellaneous/Microsoft-OLE-DB-Provider-for-ODBC-Drivers-error-80004005.aspx#
I believe, this has to be done by the hosting company. What is your take? Do you have any suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you have access to IIS (maybe through a web interface if you're being hosted by someone else), you can change the setting under the application pools that your site is using
ASKER
I am sorry for my ignorance but you are referring to 64 bit server config of the hosting company, is that right?
Should I tell them run above solution in link?
Should I tell them run above solution in link?
ASKER
Where exactly do I have to go, IIS setting? and what do I have to change?
sorry i was mixing up questions. you'll need to have them implement the solution dkirectly
You may have a query that is taking too long to execute, ask your host if they can increase the timeout else you may need to refactor your sql.
Incidentally the link you provided is for a completely different error.
Incidentally the link you provided is for a completely different error.
ASKER
@Cathal,
The link provided is for a solution that I found for the error I am getting.
The link provided is for a solution that I found for the error I am getting.
The link is for the error Data source name not found and no default driver specified connecting to Oracle
You error is Query execution was interrupted connecting to MySQL
You error is Query execution was interrupted connecting to MySQL
ASKER
When I click on the link, I am getting the link for the solution of the error I am seeing.
do you have access to change the application pool settings in IIS?
just curious, what was the issue?
ASKER
The issue was with the query not pulling one of the fields!