数据库连接已达到最大池 [英] database connection reached max pool

问题描述

亲爱的所有人，

我正面临一个问题.

我在Windows Server 2003上发布了一个Web应用程序，但是当用户登录3-4次时，它与数据库断开连接，并显示一条消息，表明它已达到最大池大小.

我正在使用Microsoft.Practices.EnterpriseLibrary.Data.Sql.
什么是解决方案>

请帮帮我.

谢谢和问候
Raghvendra

Dear all,

I am facing a problem.

I published a web application on windows server 2003, but when a user logs in 3-4 times it disconnects with database and shows a message that it has reached max pool size.

I am using Microsoft.Practices.EnterpriseLibrary.Data.Sql.
What is solution>

Please Help Me.

Thanks and regards
Raghvendra

推荐答案

关闭连接后是否调用Dispose方法?

另外，尝试将其添加到您的web.config:

Do you call the Dispose method after closing the connection?

Also, try to add this to your web.config:

<httpRuntime executionTimeout="300"/>

祝你好运！

---

此链接可能会帮助您:
http://social.msdn.microsoft.com/Forums/zh/adodotnetdataproviders/thread/c57c0432-c27b-45ab-81ca-b2df76c911ef [

Good luck!

---

This link might help you out:
http://www.eggheadcafe.com/software/aspnet/31039592/timeout-expired--the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding.aspx[^]

http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/c57c0432-c27b-45ab-81ca-b2df76c911ef[^]

将其添加到您的连接字符串中，我也遇到了同样的问题. br/>

Do add this to your connection string, I had also the same problem.

Min Pool Size=5; Max Pool Size=500;

谢谢

Thanks

这篇关于数据库连接已达到最大池的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！