ODBC Drivers error '80004005'

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




.

Relevant Pages

  • Re: Need resources for SQL Server 2000 Application Roles with ASP.NET apps
    ... The end user should never be logged directly in to sql server. ... accessing the asp pages, which in turn will access the database. ... > we intend to replace with ASP.NET applications. ... > log into Windows with their domain account information. ...
    (microsoft.public.sqlserver.security)
  • How to allow access to localhost
    ... I am running IIS and SQL Server 2000 on my Windows XP Pro ...
    (microsoft.public.windowsxp.network_web)
  • ASP app upgrade to IIS6 with new Authentication scheme
    ... with SQL Server 7. ... Windows 2003 ... information regarding straight ASP in this situation. ... information about this type of a migration (The Windows Authentication ...
    (microsoft.public.inetserver.iis.security)
  • How do I enable ASP on a W2K3 box
    ... I hava a new Windows 2003 box running IIS ... When I try and display an asp page it says page not found ... What do I have to do to allow ASP to run? ...
    (microsoft.public.inetserver.asp.general)
  • DSN less connection fro ASP pages
    ... I have installed Microsoft SQL server 2000 on a server. ... My web server is having windows NT having all asp pages. ... I want to connect to SQL Server 2000 using a DSN less ...
    (microsoft.public.sqlserver.connect)