本人的一个WEB程序在远程服务器运行时出现了下面的错误
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
查找到的资料基本有两种说明
(1)数据库连接未关闭;
(2)微软相关,具体参考 http://support.microsoft.com/kb/948868/en-us本人疑问,没看明白http://support.microsoft.com/kb/948868/en-us说得意思,You must have the .NET Framework 2.0 Service Pack 1 installed to apply this hotfix.
我应该在哪个地方去下载此System.data.dll 2.0.50727.1813版本,如何安装,谢谢诸位!
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
查找到的资料基本有两种说明
(1)数据库连接未关闭;
(2)微软相关,具体参考 http://support.microsoft.com/kb/948868/en-us本人疑问,没看明白http://support.microsoft.com/kb/948868/en-us说得意思,You must have the .NET Framework 2.0 Service Pack 1 installed to apply this hotfix.
我应该在哪个地方去下载此System.data.dll 2.0.50727.1813版本,如何安装,谢谢诸位!
不过我觉得lz的问题更像是英语语法问题,他就是说让你安装.net framework 2.0 SP1应用这个修复啊 -> have sth done (to do sth)
System.Data.dll 2.0.50727.1813 2,998,272 Feb 2008 04 - - 20:49 x 86
谢谢上面两位!
意思不是安装SP1就获得这个hotfix了吗?疑惑ing……
这个错误,应该如何修复。
偶去加分
就是告诉你sp1中有修复连接缓冲池的timeout issue的hotfix.sp1到www.update.microsoft.com去下载
Prerequisites
You must have the .NET Framework 2.0 Service Pack 1 installed to apply this hotfix.是说需要在安装有.NET Framework 2.0 Service Pack 1的情况下去应用this hotfix,But where is the hotfix? What is the hotfix? And how can I get the hotfix?STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.目前我还不清楚framework 3.5,是否包含此修复,因为此问题在本地服务器上是测不出来的,只有在远程服务器上会出现这个问题,远程服务器上还有很多其它的程序,我是不能轻易去做这种试验性的安装的。还有一点,我确认我的连接在用完之后是关闭了的!
<connectionStrings>
<add name="MemberConnString" connectionString="server=.;database=MPMember;uid=sa;pwd=;pooling=true;Max Pool Size=512;" providerName="System.Data.SqlClient"/>
</connectionStrings>没有找到根本的原因,暂时还是用的一个制标不制本的方法,在WEB.CONFIG文件中的pooling=true;后加了Max Pool Size=512;表面上解决了问题;
当时找了一些资料,基本上说得都是这几种,写在了博客里,你参考下,看是否有用,如果找到了更好的解决办法,也劳烦告知兄弟一声.
http://blog.csdn.net/ChaoYang0502/archive/2008/08/02/2757037.aspx