Solved

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Posted on 2014-02-06
12
1,472 Views
Last Modified: 2014-02-07
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?
0
Comment
Question by:perlwhite
  • 5
  • 5
  • 2
12 Comments
 
LVL 32

Accepted Solution

by:
Big Monty earned 500 total points
ID: 39839103
this is often the cause when you're switching from a 32 bit system to 64 bit, which I assume you've gone to?
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39839127
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
0
 

Author Comment

by:perlwhite
ID: 39839133
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?
0
 

Author Comment

by:perlwhite
ID: 39839139
Where exactly do I have to go, IIS setting?  and what do I have to change?
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39839157
sorry i was mixing up questions. you'll need to have them implement the solution dkirectly
0
 
LVL 58

Expert Comment

by:Gary
ID: 39839245
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.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:perlwhite
ID: 39839292
@Cathal,

The link provided is for a solution that I found for the error I am getting.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39839318
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
0
 

Author Comment

by:perlwhite
ID: 39839600
When I click on the link, I am getting the link for the solution of the error I am seeing.
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39841970
do you have access to change the application pool settings in IIS?
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39843075
just curious, what was the issue?
0
 

Author Comment

by:perlwhite
ID: 39843185
The issue was with the query not pulling one of the fields!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now