Wrox Programmer Forums
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 23rd, 2008, 10:29 AM
Friend of Wrox
Join Date: Jun 2003
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?

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

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