SQL Server connection Pool error in Debug

G

Guest

In my ASP.net application I am getting the following error...

"Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occured because all pooled connections were in
use and max pool site was reached".

This only happens when I am in debug mode. If I run SP_Who in Sql Server I
do not see many open connections. This also NEVER shows up if I run the web
application from the browser.

I cannot get this to occur if I run line by line in debug mode. I must let
it go without stopping. I cannot narrow down the location in debug either,
because it is not consitant.

I have tried increasing the timeout but that doesn't help. It just hangs
until the timeout has expired.

Searching the internet I have found others with this problem but cannot find
a solution.
 
C

Cowboy \(Gregory A. Beamer\)

Copied from my answer in microsoft.public.dotnet.framework.aspnet:

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

My guess: The timeout is happening in the SQL debugger itself.

Solution:

Right click the solution and choose Properties
Click Debug (or Debugging) under Configuration Properties

If VB.NET
Find Enabled Debuggers and clear the SQL Server Debugging checkbox

If C#
Find Debuggers and Change Enable SQL Debugging to false

These dialogs were designed by the language teams.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************
 
G

Guest

That fixed my problem. Thank you!
--
Jerry J


Cowboy (Gregory A. Beamer) said:
Copied from my answer in microsoft.public.dotnet.framework.aspnet:

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

My guess: The timeout is happening in the SQL debugger itself.

Solution:

Right click the solution and choose Properties
Click Debug (or Debugging) under Configuration Properties

If VB.NET
Find Enabled Debuggers and clear the SQL Server Debugging checkbox

If C#
Find Debuggers and Change Enable SQL Debugging to false

These dialogs were designed by the language teams.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*********************************************
Think outside the box!
*********************************************
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connection status "suspended" 2
Timeout - max pool size reached 7
Timeout expired connection 2
Connection Pool and Connection time out 4
ado.net, connection pooling, and leaked connections 8
connection timeout 2
Severed connections in SQL Server Connection Pool 1
Error:max pool size was reached 3

Top