Please post your code for the page that is causing the error. We might be able to help if we can see what is going on.
It sounds like you are opening a connection to the pool and not closing it properly. Connection pooling is a way to speed up your application by using connections to the database that are already open. Most of the time pool problems come from a "connection leak" You must manually close all of your connections. If you don't, then the ADO.Net process must wait for the Garbage Collector (GC) cleans up the connections. This may take hours in some cases. Thanks --Eric Cantrall [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Eric Throckmorton [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 10:46 AM To: [email protected] Subject: RE: [AspNetAnyQuestionIsOk] Timeout expired DAL (Data Access Layer). OK, makes sense to me. I didn't know what it was - Database Abstraction Layer is something I remember about when I was reading php stuff, I don't use it either. So, what I need to do is free up some connections to the pool. Is using pooled connections a bad idea? Or am I just leaving too many open... What DAL code will I need to learn this? Thank-you "Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> wrote: Sorry DAL is an acronym we use (at least at The Hartford) for Data Access Layer. Basically it seems when you access your database you are doing it via a pool and there aren't any free connections in the pool to use. Now I noticed you mentioned PHP; I am assuming you are coding in .net on this list... I am no PHP guy that is for sure... java, .Net, Action Script, and groovy sure... PHP nope. ;-) Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 9:52 AM To: [email protected] Subject: RE: [AspNetAnyQuestionIsOk] Timeout expired I'd be glad to. Do you know where I can find this DAL code? I do not recall any php in my coding so this must be generated some other way. Let me know and will post it so you can see what me be happening. Thank-you. "Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> wrote:It looks like you are trying to grab a connection out of a connection pool and they are all being used and that the attempt to get a connection is timing out. Post some of your DAL code and we can try to see what's going on. Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 9:22 AM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Timeout expired Can someone please tell me how to debug this error?: 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. at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection (SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at... Thank-you Yahoo! Groups Links ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspNetAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Basic programming language Computer programming languages Programming languages Java programming language --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspNetAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] _____ YAHOO! GROUPS LINKS * Visit your group "AspNetAnyQuestionIsOk <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] e> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
