SQLConnection.Open() Timeout Error - but...nothing has changed?

[Nevyn Twyll]

I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or on
my server, I'm getting a timeout when trying to open a database connection.
The error seems to happen regardless of what ASP.NET app I'm working
with/trying to debug.
It will open a few connections,

Here's the error:


Server Error in '/MyApplication' 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.InvalidOperationException: 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 156:
Line 157: // Open the database connection and execute the command
Line 158: myConnection.Open();
Line 159: SqlDataReader result =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Line 160:

Source File:
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs Line:
158

Stack Trace:

[InvalidOperationException: 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.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) in
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs:158
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs e)
in F:\dev\CeltTech\EquityCheck\EquityCheck\Global.asax.cs:47
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87





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

Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032

The connection string I use in my web.config is:

<add key="ConnectionString"
value="server=manwe;Trusted_Connection=false;database=MyDatabase;Application
Name=MyApplication;User ID=sqluser; Password=sqlpassword;"/>

Help?

[Juan T. Llibre]

Are you closing your connections after you've
finished retrieving or writing data with them ?



Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

Post by Nevyn Twyll
I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or
on my server, I'm getting a timeout when trying to open a database
connection.
The error seems to happen regardless of what ASP.NET app I'm working
with/trying to debug.
It will open a few connections,
Server Error in '/MyApplication' 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.InvalidOperationException: 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.
Line 157: // Open the database connection and execute the command
Line 158: myConnection.Open();
Line 159: SqlDataReader result =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs
Line: 158
[InvalidOperationException: 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.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) in
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs:158
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs e)
in F:\dev\CeltTech\EquityCheck\EquityCheck\Global.asax.cs:47
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET Version:1.1.4322.2032
<add key="ConnectionString"
value="server=manwe;Trusted_Connection=false;database=MyDatabase;Application
Name=MyApplication;User ID=sqluser; Password=sqlpassword;"/>
Help?

...

[Nevyn Twyll]

Yes - I just went through and made sure that was happening, and that my
datareaders were ComandBehavior.CloseConnection.

Post by Juan T. Llibre
Are you closing your connections after you've
finished retrieving or writing data with them ?
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

Post by Nevyn Twyll
I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or
on my server, I'm getting a timeout when trying to open a database
connection.
The error seems to happen regardless of what ASP.NET app I'm working
with/trying to debug.
It will open a few connections,
Server Error in '/MyApplication' 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.InvalidOperationException: 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.
Line 157: // Open the database connection and execute the command
Line 158: myConnection.Open();
Line 159: SqlDataReader result =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);
158
[InvalidOperationException: 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.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) in
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs:158
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs
e) in F:\dev\CeltTech\EquityCheck\EquityCheck\Global.asax.cs:47
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET Version:1.1.4322.2032
<add key="ConnectionString"
value="server=manwe;Trusted_Connection=false;database=MyDatabase;Application
Name=MyApplication;User ID=sqluser; Password=sqlpassword;"/>
Help?

...

[Nevyn Twyll]

And the weird thing is, if I deploy the application to an IIS server, and
run it there, it seems fine....

Post by Juan T. Llibre
Are you closing your connections after you've
finished retrieving or writing data with them ?
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

Post by Nevyn Twyll
I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or
on my server, I'm getting a timeout when trying to open a database
connection.
The error seems to happen regardless of what ASP.NET app I'm working
with/trying to debug.
It will open a few connections,
Server Error in '/MyApplication' 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.InvalidOperationException: 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.
Line 157: // Open the database connection and execute the command
Line 158: myConnection.Open();
Line 159: SqlDataReader result =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);
158
[InvalidOperationException: 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.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) in
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs:158
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs
e) in F:\dev\CeltTech\EquityCheck\EquityCheck\Global.asax.cs:47
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET Version:1.1.4322.2032
<add key="ConnectionString"
value="server=manwe;Trusted_Connection=false;database=MyDatabase;Application
Name=MyApplication;User ID=sqluser; Password=sqlpassword;"/>
Help?

...

[Juan T. Llibre]

Are you using XP as a Dev box ?

I think there's an issue with the max number
of connections available through XP.

Same for MSDE...



Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

Post by Nevyn Twyll
And the weird thing is, if I deploy the application to an IIS server, and
run it there, it seems fine....

Post by Juan T. Llibre
Are you closing your connections after you've
finished retrieving or writing data with them ?
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

Post by Nevyn Twyll
I've been working on an asp.net application and everything's been great.
But suddenly, whether I'm tyring to use a database on my own machine, or
on my server, I'm getting a timeout when trying to open a database
connection.
The error seems to happen regardless of what ASP.NET app I'm working
with/trying to debug.
It will open a few connections,
Server Error in '/MyApplication' 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.InvalidOperationException: 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.
Line 157: // Open the database connection and execute the command
Line 158: myConnection.Open();
Line 159: SqlDataReader result =
myCommand.ExecuteReader(CommandBehavior.CloseConnection);
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs
Line: 158
[InvalidOperationException: 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.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +396
System.Data.SqlClient.SqlConnection.Open() +384
ASPNetPortal.PortalSettings..ctor(Int32 tabIndex, Int32 tabId) in
f:\dev\celttech\equitycheck\equitycheck\components\configuration.cs:158
ASPNetPortal.Global.Application_BeginRequest(Object sender, EventArgs
e) in F:\dev\CeltTech\EquityCheck\EquityCheck\Global.asax.cs:47
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET Version:1.1.4322.2032
<add key="ConnectionString"
value="server=manwe;Trusted_Connection=false;database=MyDatabase;Application
Name=MyApplication;User ID=sqluser; Password=sqlpassword;"/>
Help?

...