Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 23rd, 2008, 10:29 AM
Friend of Wrox
Points: 2,876, Level: 22
Points: 2,876, Level: 22 Points: 2,876, Level: 22 Points: 2,876, Level: 22
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Denver, CO, USA.
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
Default Find open DB Connection again

Sorry to repost this, but the response I got did not answer the question and somebody who might have an answer could skip the question as it appears to have gotten a response. Nor did I get an email indicating I received a response despite subscribing to the topic, if anybody from P2P is reading this.

Anyway, I am still randomly getting this error every few days:

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.

I don't wish to increase pool size or turning off pooling as those don't really fix the problem. And I don't need advice on how I should've coded it. I just need to find the leak.

Is there any way to figure out which connection(s) are being left open? There is a lot of code to be checked, so randomly searching for this problem is unlikely to find it, and a trace could potentially turn up hundreds of DB calls that would be as painful to search as the code itself. Are there any tools or techniques that can help me quickly find where in my code connections are being left open?
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Open DB Connections? Ron Howerton ASP.NET 2.0 Professional 6 April 23rd, 2008 12:29 PM
Attaching a DB - can't find desktop rsearing SQL Server 2005 1 July 4th, 2007 09:56 PM
asp can't open db when db open by other program datuk Classic ASP Professional 3 June 13th, 2006 06:10 PM
Open Word Doc from Access - find, find next save donaldmaloney Access VBA 1 May 25th, 2005 11:09 AM
Access DB Connection (Jet cannot Open) M.L.Srinivas Classic ASP Databases 7 October 8th, 2003 08:21 AM



All times are GMT -4. The time now is 02:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.