MS SQL Server ODBC - ODBC Drivers error '80004005'

Author

ODBC Drivers error '80004005'

Dannyb

2006-02-21, 3:23 am

Hello, I am running IIS 6.0 on a windows 2003 server. I have an asp page
that accessed a SQL server 2000 running on windows 2003 through DSN. Every
once in a while the webpage becomes inaccessable and gives the following
message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB] General network error.
Check your network documentation.
/direct/dbConn.asp, line 34

Line 34 of the asp file contains the line:
adoCon.Open " dsn=DatabaseConnect;
uid=login;pwd=test"

The webpage doesn't just comeback after a few minutes but instead stays
inaccessible until the SQL Server is restarted.
The only way around this problem has been to restart the SQL server every 3
hours in order to decrease the webserver downtime.
Please help,
Danny

Dannyb

2006-03-08, 9:23 am

It looks like an upgrade to SQL Server 2000 Service Pack 4 solved the
problem.

Dannyb
"Dannyb" <dannyb@alianza.com> wrote in message
news:uPpKjQqNGHA.740@TK2MSFTNGP12.phx.gbl...
> Hello, I am running IIS 6.0 on a windows 2003 server. I have an asp page
> that accessed a SQL server 2000 running on windows 2003 through DSN.
> Every
> once in a while the webpage becomes inaccessable and gives the following
> message:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][DBNETLIB] General network error.
> Check your network documentation.
> /direct/dbConn.asp, line 34
>
> Line 34 of the asp file contains the line:
> adoCon.Open " dsn=DatabaseConnect;
uid=login;pwd=test"
>
> The webpage doesn't just comeback after a few minutes but instead stays
> inaccessible until the SQL Server is restarted.
> The only way around this problem has been to restart the SQL server every
> 3
> hours in order to decrease the webserver downtime.
> Please help,
> Danny
>
>
>
>

Sponsored Links