[DBNETLIB] [ConnectionOpen（Connect（））。] SQL Server不存在或访问被拒绝。 [英] [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

问题描述

在asp页面

我得到这个错误我怎么能解决它..

昨天代码工作但是我设置了visual studio 6.0现在它没有

有效..

in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..

推荐答案

你的连接字符串是什么样的？您是否通过其主机名连接到SQL

服务器？如果是这样，您的服务器可以解析该名称吗？

之间是否有防火墙？服务器的网络电缆是否已拔下？


Ray在工作中

Savas Ates < SA *** @ indexinteractive.com>在消息中写道

新闻：uQ ************** @ TK2MSFTNGP15.phx.gbl ...

What does your connection string look like? Are you connecting to the SQL
Server by its host name? If so, can your server resolve that name? Is
there a firewall in between? Is the server''s network cable unplugged?

Ray at work
"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...

在asp页面昨天代码工作，但我设置Visual Studio 6.0现在它没有
工作..

in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..

我有同样的问题。我们最近将我们的ASP应用程序从Windows 2000迁移到了

Windows 2003 Web服务器，当我们这样做时，我们的问题开始突然出现了b
。当我们迁移到新服务器时，我们还将连接字符串

从使用ODBC DSN更改为OLEDB连接字符串。要解决原因，我们将修改后的应用程序复制回2000框，完成新的连接字符串

，并且从未看到错误发生在那里。我们已经尝试过添加Network Library = dbmssocn添加&b
进入我们的连接字符串，但是

没有帮助。我们将SQL服务器添加到主机& lmhosts.sam文件和

在SQL服务器上做了同样的事情（将Web服务器添加到文件中） - 但是

没有帮助。我们使用客户端网络实用程序来启用TCP / IP

&在网络服务器上命名管道 - 但这没有帮助。


我在谷歌上看到太多其他帖子认为这是一个孤立的

问题。我也看过一些帖子让我相信从Win2000到Win2003有一些东西可以用来支付
。


这个错误非常零星。我们整天都在应用程序上有100多个用户，并且只在错误发生的情况下偶尔会出现
。如果用户在错误发生后立即刷新

，则连接工作正常。

请帮忙！


Scott Ivey



" Ray Costanzo [MVP]" <我的第34号商业广告的名字>写在

消息新闻：％2 **************** @ tk2msftngp13.phx.gbl ...

I have the same problem. We recently moved our ASP app from Windows 2000 to
Windows 2003 Web servers, and when we did this our problems started popping
up. When we moved to the new servers, we also changed the connect strings
from using ODBC DSN''s to OLEDB connect strings. To troubleshoot if that was
the cause, we copied the modified app back to the 2000 box, complete with
the new connect strings, and never saw the error happen there. We''ve tried
adding adding "Network Library=dbmssocn" into our connect strings, but that
didn''t help. We added the SQL server to the hosts & lmhosts.sam files, and
did the same on the SQL server (added the web servers to the files) - but
that didn''t help. We used the client network utility to enable both TCP/IP
& Named Pipes on the web servers - but that didn''t help.

I''ve seen too many other posts on google to believe that this is an isolated
problem. I''ve also seen posts that made me believe that this has something
to do with going from Win2000 to Win2003.

The error is very sporadic. We have 100+ users on the app all day long, and
only every once in a while the error happens. If the user hits refresh
right after the error, the connection work just fine.
Please help!

Scott Ivey


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%2****************@tk2msftngp13.phx.gbl...

什么你的连接字符串看起来像？您是否通过其主机名连接到SQL
服务器？如果是这样，您的服务器可以解析该名称吗？
之间是否有防火墙？服务器的网络电缆是否已拔下？

Ray在工作中

Savas Ates < SA *** @ indexinteractive.com>在消息中写道
新闻：uQ ************** @ TK2MSFTNGP15.phx.gbl ...

What does your connection string look like? Are you connecting to the SQL
Server by its host name? If so, can your server resolve that name? Is
there a firewall in between? Is the server''s network cable unplugged?

Ray at work
"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...

在asp页面
即时通讯这个错误我怎么能解决它..
昨天代码工作但是我设置了visual studio 6.0现在它没有工作..

in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..

您是否通过名称，外部IP，内部IP连接到服务器......？


您能否显示连接不起作用的字符串和ODBC参数

有效吗？


-
http://www.aspfaq.com/

（反向回复地址。）



" Scott Ivey" < SI *** @ online.nospam>在留言中写道

新闻：Os ************** @ TK2MSFTNGP09.phx.gbl ...

Are you connecting to the server by name, external IP, internal IP, ...?

Can you show the connection string that doesn''t work and the ODBC parameters
that work?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Scott Ivey" <si***@online.nospam> wrote in message
news:Os**************@TK2MSFTNGP09.phx.gbl...

我有同样的问题。我们最近将我们的ASP应用程序从Windows 2000
移到了Windows 2003 Web服务器，当我们这样做时，我们的问题就出现了
。当我们迁移到新服务器时，我们还将连接字符串从使用ODBC DSN更改为OLEDB连接字符串。要解决如果
是原因，我们将修改后的应用程序复制回2000框，完成新的连接字符串，并且从未看到错误发生在那里。我们已经尝试添加网络库= dbmssocn
进入我们的连接字符串，但
没有帮助。我们将SQL服务器添加到主机& lmhosts.sam文件，
并在SQL服务器上做了同样的事情（将Web服务器添加到文件中） - 但是
没有帮助。我们使用客户端网络实用程序来启用
TCP / IP&在网络服务器上命名管道 - 但这没有帮助。

我在谷歌上看到太多其他帖子，认为这是一个
孤立的问题。我也看过一些帖子，让我相信这有从bb2000到Win2003的
。

这个错误是非常零星的。我们整天都在应用程序上有100多个用户，
并且每隔一段时间就会发生错误。如果用户在错误发生后立即点击刷新，则连接工作正常。

请帮忙！

Scott Ivey

< br> Ray Costanzo [MVP]" <我的第34号商业广告的名字>在
消息新闻中写道：％2 **************** @ tk2msftngp13.phx.gbl ...

I have the same problem. We recently moved our ASP app from Windows 2000 to Windows 2003 Web servers, and when we did this our problems started popping up. When we moved to the new servers, we also changed the connect strings
from using ODBC DSN''s to OLEDB connect strings. To troubleshoot if that was the cause, we copied the modified app back to the 2000 box, complete with
the new connect strings, and never saw the error happen there. We''ve tried adding adding "Network Library=dbmssocn" into our connect strings, but that didn''t help. We added the SQL server to the hosts & lmhosts.sam files, and did the same on the SQL server (added the web servers to the files) - but
that didn''t help. We used the client network utility to enable both TCP/IP & Named Pipes on the web servers - but that didn''t help.

I''ve seen too many other posts on google to believe that this is an isolated problem. I''ve also seen posts that made me believe that this has something to do with going from Win2000 to Win2003.

The error is very sporadic. We have 100+ users on the app all day long, and only every once in a while the error happens. If the user hits refresh
right after the error, the connection work just fine.
Please help!

Scott Ivey


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%2****************@tk2msftngp13.phx.gbl...

你的连接字符串是什么样的喜欢？您是否通过其主机名连接到
SQL Server？如果是这样，您的服务器可以解析该名称吗？
之间是否有防火墙？服务器的网络电缆是否已拔下？

Ray在工作中

Savas Ates < SA *** @ indexinteractive.com>在消息中写道
新闻：uQ ************** @ TK2MSFTNGP15.phx.gbl ...

What does your connection string look like? Are you connecting to the SQL Server by its host name? If so, can your server resolve that name? Is
there a firewall in between? Is the server''s network cable unplugged?

Ray at work
"Savas Ates" <sa***@indexinteractive.com> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...

在asp页面
即时通讯这个错误我怎么能解决它..
昨天代码工作但是我设置了visual studio 6.0现在它没有工作..

in asp page
im getting this error how can i solve it..
yesterday the codes work but i setup visual studio 6.0 now it doesnt
works..

这篇关于[DBNETLIB] [ConnectionOpen（Connect（））。] SQL Server不存在或访问被拒绝。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！