HELP - connectivity with asp and SQL Server

[patty]

I have a problem with internal websites written in ASP that connect to
SQL Server.
Occassionally while trying to access these sites, the following error
is generated:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
/Mvp/admin_login.asp, line 0


I've looked on MS site and the solutions seem to be for problems that
are consistant. Sometimes the sites can be accessed other times they
cannot. Does anyone have any ideas what could be causing the server to
time out?

 

[Bob Barrows [MVP]]

I have a problem with internal websites written in ASP that connect to
SQL Server.
Occassionally while trying to access these sites, the following error
is generated:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
/Mvp/admin_login.asp, line 0


I've looked on MS site and the solutions seem to be for problems that
are consistant. Sometimes the sites can be accessed other times they
cannot. Does anyone have any ideas what could be causing the server to
time out?

Bad programming practices may be preventing connection pooling from working,
causing your sql server to fail to respond due to too many connections open
against it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328476

 

[patty]

Thank you! I need to try this on Mon. & see if it fixes the problem.
I'm not a programmer nor did I write the applications. Unfortunately,
I'm just the person who needs to fix the problem. Thanks again!

I have a problem with internal websites written in ASP that connect to
SQL Server.
Occassionally while trying to access these sites, the following error
is generated:

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
/Mvp/admin_login.asp, line 0


I've looked on MS site and the solutions seem to be for problems that
are consistant. Sometimes the sites can be accessed other times they
cannot. Does anyone have any ideas what could be causing the server to
time out?

Bad programming practices may be preventing connection pooling from working,
causing your sql server to fail to respond due to too many connections open
against it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;328476

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"