问题描述
我们在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
来自
发布于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
推荐答案
可能是这个吗？
-
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.
这篇关于ASP到SQL Server - 间歇性连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！