If this question is inappropriate for this group I apologize. With the
wealth of knowledge here I hoped it was a good place to start.

I get the following error

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

/Purchased/Wiring/TrackUsage.Asp, line 51



from the following code:

strconn = "Provider=SQLOLEDB;Data Source=192.168.254.100;Initial
Catalog=Mitchell1;Network=DBMSSOCN;User Id=AEPUsage;Password=AEPUsage"
set conn = server.createobject("adodb.connection")

strSQL=" Insert into AEPUsage (CurrentUser,CurrentPage,CurrentDate, Partno)
"
strSQL=strSQL & "
Values('"&CurrentUser&"','"&CurrentPage&"','"&CurrentDate&"','"&cPartNo&"')"

conn.open strconn ' <----this is line 51

The problem is that the code has worked for years, and now will only run for
3 day before the error starts.

This is a very small database running on SQL server 7 on W2K server. IIS is
on the same box.

When it fails I have tried restarting each individual service on the box
(MSSQL, IIS,etc.), but the only thing that fixes it is a complete restart of
the box. During the problem I can still login with QA using the same
credentials that the application uses on either the box, or another box on
the network.



Any thoughts on how to track what is causing the login to fail?
Unfortunately now I will have to wait 3 days to test any suggestions.



Mark


MS Sql Server LazyDBA home page