ASP, ODBC, SQL 2000 Server Timeout

[Andrew J Durstewitz]

I've noticed a few times yesterday I recived this error on my web
server:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.

I know for sure the server is running and at the time was under a load
of about 2,900 page views for the hour. By far not my largest audience.

What could cause this? Is ODBC having some issues?

FYI, the database server isn't on the web server, they are physically
two different machines connected via LAN.

DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.

[Vilmar Brazão de Oliveira]

HI, by what I know untill now ADOOLEDB is so much better than ODBC, so use
this to connect you SQL Server Data Base:
<%
Dim Conexao
Set Conexao = Server.CreateObject("adodb.connection")
Conexao.Open "Provider=SQLOLEDB.1;Password=XX;Persist Security
Info=True;User ID=sa;Initial Catalog=DB_NAME or IP;Data Source=SQLServer"
%>
--

BYE,

««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Andrew J Durstewitz" <ad*********@moreheadassociates.com> escreveu na
mensagem news:40*********************@news.frii.net...

I've noticed a few times yesterday I recived this error on my web
server:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.

I know for sure the server is running and at the time was under a load
of about 2,900 page views for the hour. By far not my largest audience.

What could cause this? Is ODBC having some issues?

FYI, the database server isn't on the web server, they are physically
two different machines connected via LAN.

DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.