Hosted site craching DB layer (SQL Server does not exist or access denied)

I'm having mega problems with a large database-driven site that's
hosted on a reputable ISP's W2K webserver and SQL2K database server.
It seems for some while it's been causing them problems (unknown to
us) with connectivity between the webserver and db server. When the
problem occurs the hosted sites get the following error message (or
similar):

"Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied."

Now the site itself is not high volume nor db intensive but the
problem is arrising every few days. The ISP has moved the site between
servers at least 3 times now and asserts that the problem moves with
the site - I still cannot see what can be causing the problem and have
found it hard to be convinced it is our site anyway. Nonetheless if we
don't sort it we'll get the site suspended - ooerr!

All the ASB (VBS-based) site does is use ADO to interact with the DB
thru queries and a few small stored procedures. I've been thru and
checked that all connections are closed and the objects destroyed
after use. It was pointed out that it uses only implicit connections
(eg rs.Open strSQL, strProvider rather than opening a connection and
using the connection object trhoughout the page).

Anyone got any suggestions for what might be causing the problem or
even where I start looking as I cannot reproduce the problem locally
and of course only have very limited access to the host system. Also
there doesn't seem to be anything that can be monitored to anticipate
the problem occurring.

Help!!

RB

Re: Hosted site craching DB layer (SQL Server does not exist or access denied)

Roland Burr wrote:
> I'm having mega problems with a large database-driven site that's
> hosted on a reputable ISP's W2K webserver and SQL2K database server.
> It seems for some while it's been causing them problems (unknown to
> us) with connectivity between the webserver and db server. When the
> problem occurs the hosted sites get the following error message (or
> similar):
>
> "Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied."
>
> Now the site itself is not high volume nor db intensive but the
> problem is arrising every few days. The ISP has moved the site between
> servers at least 3 times now and asserts that the problem moves with
> the site - I still cannot see what can be causing the problem and have
> found it hard to be convinced it is our site anyway. Nonetheless if we
> don't sort it we'll get the site suspended - ooerr!
>
> All the ASB (VBS-based) site does is use ADO to interact with the DB
> thru queries and a few small stored procedures. I've been thru and
> checked that all connections are closed and the objects destroyed
> after use. It was pointed out that it uses only implicit connections
> (eg rs.Open strSQL, strProvider rather than opening a connection and
> using the connection object trhoughout the page).
>

Well, that may be an issue. Would it be a lot of work to recode it to use
explicit connections?

Otherwise, I see you are using DBNETLIB. You might want to swtich it to use
TCP/IP using the "network library" attribute in your connection string. See
www.able-consulting.com/ado_conn.htm for details

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.