469,336 Members | 6,002 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

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 1916
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
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.