ASP到SQL Server - 间歇性连接问题 [英] ASP to SQL Server - Intermittent connection problems

问题描述

我们在Windows 2003 SP1服务器上运行了相当多的ASP.NET应用程序。整套软件最初是用ASP编写的，在Win 2k服务器上运行。大约去年，我们一直致力于将所有内容转换为.NET，我们即将完成所有这些工作。与此同时，我们仍然有一些软件在经典ASP中运行。


这是问题所在。直到大约两个月前，ASP页面才非常可靠。我们将生产服务器从Win 2k升级到Win 2k3（现在是SP1）并在加载ASP页面时开始出现间歇性错误。


Microsoft OLE DB Provider for SQL Server错误''80004005' '

[DBNETLIB] [ConnectionOpen（Connect（））。] SQL Server不存在或访问被拒绝。

/2003/PageName.asp,line#.


这通常发生在具有较大数据集的页面上以及某些数据已加载之后。使用相同的连接检索页面上的所有数据，因此我知道连接字符串是正常的。这发生在页面中的不同点，只会偶尔发生一次。看起来它可能依赖于服务器上的负载。


我已经搜索了这个问题并发现了其他有关此类行为的帖子，但没有发布任何解决方案。如果有人有想法或已经看到同样的问题并看到它已修复，请告诉我你找到了什么。


提前致谢！

Dan


来自 http ：//developmentnow.com/g/62_0_0_0...sp-general.htm

发布于DevelopmentNow.com网站
http://www.developmentnow.com

We have a fairly large set of ASP.NET applications running on Windows 2003 SP1 server. The entire suite of software was originally written in ASP and ran on a Win 2k server. For about the last year, we have been working toward converting everything to .NET and we are close to have it all done. In the mean time, we still have a few portions of the software running in classic ASP.

Here is the problem. The ASP pages have been pretty reliable up until about two months ago. We upgraded our production servers from Win 2k to Win 2k3 (now SP1) and started getting intermittent errors when loading an ASP page.

Microsoft OLE DB Provider for SQL Server error ''80004005''
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/2003/PageName.asp, line #.

This generally happens on pages with larger sets of data and AFTER some of the data has loaded. All data on the page is retreived using te same connection so I do know that the connection string is ok. This happens at different points in the page and only happens once in a while. It looks like it may be dependant on the load on the servers.

I have googled this problem and found other postings concerning this same type of behaviour, but no solutions have been posted. If anyone has an idea or has seen this same problem and seen it fixed, PLEASE let me know what you have found.

Thanks in advance!
Dan

From http://developmentnow.com/g/62_0_0_0...sp-general.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

推荐答案

Dan写道：

我们在Windows的2003 SP1服务器上运行了一大堆ASP.NET应用程序。整套软件最初是用ASP编写的，在Win 2k服务器上运行。大约去年，我们一直致力于将所有内容转换为.NET，并且我们已经接近完成了这一切。与此同时，我们仍然有一些软件在经典ASP中运行。

这就是问题所在。直到大约两个月前，ASP页面才非常可靠。我们将生产服务器从
Win 2k升级到Win 2k3（现在是SP1）并在加载ASP页面时开始出现间歇性错误。

用于SQL Server的Microsoft OLE DB提供程序错误''80004005''
[DBNETLIB] [ConnectionOpen（Connect（））。] SQL Server不存在或
访问被拒绝。 /2003/PageName.asp,行＃。

We have a fairly large set of ASP.NET applications running on Windows
2003 SP1 server. The entire suite of software was originally written
in ASP and ran on a Win 2k server. For about the last year, we have
been working toward converting everything to .NET and we are close to
have it all done. In the mean time, we still have a few portions of
the software running in classic ASP.

Here is the problem. The ASP pages have been pretty reliable up
until about two months ago. We upgraded our production servers from
Win 2k to Win 2k3 (now SP1) and started getting intermittent errors
when loading an ASP page.

Microsoft OLE DB Provider for SQL Server error ''80004005''
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. /2003/PageName.asp, line #.

可能是这个吗？
http://support.microsoft.com/?kbid=328476


-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。我的From

标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。

Could it be this?
http://support.microsoft.com/?kbid=328476

--
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.

感谢您的回复快速回复。我不相信这是问题

但是因为我们确实启用了连接池。


***通过Developersdex发送 http://www.developersdex.com ***

Thanks for the fast reply. I don''t believe that this is the problem
though because we do have connection pooling enabled.

*** Sent via Developersdex http://www.developersdex.com ***

您可以尝试增加连接的超时时间。默认情况下，它是
是15秒，但如果服务器真的很忙...


-

Sylvain Lafontaine， ing。

MVP - 技术虚拟PC

电子邮件： http://cerbermail.com/?QugbLEWINF

Dan < DN *********** @ yahoo.com>在消息中写道

新闻：OV ************* @ TK2MSFTNGP12.phx.gbl ...

You can try to augment the timeout time for the connection. By default, it
is 15 seconds but if the server is really busy...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Dan" <dn***********@yahoo.com> wrote in message
news:OV*************@TK2MSFTNGP12.phx.gbl...

但因为我们确实启用了连接池。

***通过Developersdex发送 http://www.developersdex.com ***

这篇关于ASP到SQL Server - 间歇性连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！