eurozero
asked on
Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
Hi there, I have 2 servers, web and SQL server. Both running in Windows 2003 server with IIS6 and MSSQL 2000 installed respectively. Basically the web server runs ASP codes and connects to the SQL server. All the updates are installed and everything runs fine for years.
Problem starts happening today, with all the pages cannot be shown (not only .asp pages but also .html pages, and even gif and jpg image files, as weird as you can imagine) giving varies errors. When I restart IIS or even rebooting both servers, the pages run fine for a while, and the same errors start coming out within 5 minutes. The error message coming out most of the time is shown as below:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed"
... or just simple "HTTP/1.1 500 Server Error"...
I've tried reinstalling IIS, even uninstall all the .NET frameworks and install the newest .NET framework 4.0, but no miracle happens.
Obviously a nightmare for me and everybody in the office is screaming at me, as expected....
Any solution?
Problem starts happening today, with all the pages cannot be shown (not only .asp pages but also .html pages, and even gif and jpg image files, as weird as you can imagine) giving varies errors. When I restart IIS or even rebooting both servers, the pages run fine for a while, and the same errors start coming out within 5 minutes. The error message coming out most of the time is shown as below:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed"
... or just simple "HTTP/1.1 500 Server Error"...
I've tried reinstalling IIS, even uninstall all the .NET frameworks and install the newest .NET framework 4.0, but no miracle happens.
Obviously a nightmare for me and everybody in the office is screaming at me, as expected....
Any solution?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
I have no access to web server, thus difficult for me to check what was happened there, btw from db area, what can I says to them if this not really db performance issues?
I have no access to web server, thus difficult for me to check what was happened there, btw from db area, what can I says to them if this not really db performance issues?
ASKER