Time out issue to connect to Sql server

[Dale]

Hi,
I encountered this error when I debug my asp.net web application.
What might be the reason? How can I resolve this? Thanks!

Server Error in '/ETS' Application.
----------------------------------------------------------------------------
----

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.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: 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.

Source Error:
Line 224:
Line 225: if (conn.State != ConnectionState .Open)
Line 226: conn.Open();
Line 227:
Line 228: cmd.Connection = conn;
Source File: C:\Inetpub\wwwr oot\ETS\ETS.Fra mework\DAL\SqlH elper.cs Line:
226

Stack Trace:
[InvalidOperatio nException: 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.]

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
ETS.Framework.D AL.SqlHelper.Pr epareCommand(Sq lCommand cmd, SqlConnection
conn, SqlTransaction trans, CommandType cmdType, String cmdText,
SqlParameter[] cmdParms) in
C:\Inetpub\wwwr oot\ETS\ETS.Fra mework\DAL\SqlH elper.cs:226
ETS.Framework.D AL.SqlHelper.Ex ecuteReader(Str ing connString, CommandType
cmdType, String cmdText, SqlParameter[] cmdParms) in
C:\Inetpub\wwwr oot\ETS\ETS.Fra mework\DAL\SqlH elper.cs:129
ETS.Business.DA L.SQLDataAccess Layer.GetCampus ByCode(String CampusCode) in
C:\Inetpub\wwwr oot\ETS\ETS.Bus iness\DAL\SQLDa taAccessLayer.c s:401
ETS.Business.BL L.Campus.GetCam pusByCode(Strin g CampusCode) in
C:\Inetpub\wwwr oot\ETS\ETS.Bus iness\BLL\Campu s.cs:68
ETS.Web.UserCon trol.Menu.Page_ Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\ETS\UserCon trol\Menu.ascx. cs:21
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

----------------------------------------------------------------------------
----

Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET
Version:1.1.432 2.573

[Scott Allen]

Dale:

Does this only happen when you are in the debugger?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 7 Jun 2005 16:11:34 +0800, "Dale" <xi**********@i ntel.com>
wrote:

Hi,
I encountered this error when I debug my asp.net web application.
What might be the reason? How can I resolve this? Thanks!

Server Error in '/ETS' Application.
----------------------------------------------------------------------------
----

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.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidO perationExcepti on: 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.

Source Error:
Line 224:
Line 225: if (conn.State != ConnectionState .Open)
Line 226: conn.Open();
Line 227:
Line 228: cmd.Connection = conn;
Source File: C:\Inetpub\wwwr oot\ETS\ETS.Fra mework\DAL\SqlH elper.cs Line:
226

Stack Trace:
[InvalidOperatio nException: 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.]

System.Data.Sq lClient.SqlConn ectionPoolManag er.GetPooledCon nection(SqlConn ec
tionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
ETS.Framework.D AL.SqlHelper.Pr epareCommand(Sq lCommand cmd, SqlConnection
conn, SqlTransaction trans, CommandType cmdType, String cmdText,
SqlParameter[] cmdParms) in
C:\Inetpub\www root\ETS\ETS.Fr amework\DAL\Sql Helper.cs:226
ETS.Framework.D AL.SqlHelper.Ex ecuteReader(Str ing connString, CommandType
cmdType, String cmdText, SqlParameter[] cmdParms) in
C:\Inetpub\www root\ETS\ETS.Fr amework\DAL\Sql Helper.cs:129
ETS.Business.DA L.SQLDataAccess Layer.GetCampus ByCode(String CampusCode) in
C:\Inetpub\www root\ETS\ETS.Bu siness\DAL\SQLD ataAccessLayer. cs:401
ETS.Business.BL L.Campus.GetCam pusByCode(Strin g CampusCode) in
C:\Inetpub\www root\ETS\ETS.Bu siness\BLL\Camp us.cs:68
ETS.Web.UserCon trol.Menu.Page_ Load(Object sender, EventArgs e) in
c:\inetpub\www root\ETS\UserCo ntrol\Menu.ascx .cs:21
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()

----------------------------------------------------------------------------
----

Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET
Version:1.1.43 22.573