471,892 Members | 1,963 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,892 software developers and data experts.

ASP, ODBC, SQL 2000 Server Timeout

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.
Jul 19 '05 #1
1 1981
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.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by loi.tan.vo | last post: by
6 posts views Thread by Nifty | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.