Home Discussions Namespaces Framework Contact Blog

Logon or Create an Account

What todo when: The timeout period elapsed prior to obtaining a connection from the pool Messages   Related Types This message was discovered on microsoft.public.dotnet.framework.aspnet. Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions. Post a new message to this list... Andreas Klemt GOOD ANSWER Hello, I have this Error Message: 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. Stack Trace: at System.Data.SqlClient.SqlConnection.Open() What does this mean and how and where can I fix this problem? Thanks in advance!! Andreas Reply to this message... Vote that this is a GOOD answer... (1 vote from another user already)          Steve C. Orr, MCSD (VIP) GOOD ANSWER You can only have so many connections to your SQL Server database. You can buy more licenses from Microsoft if you don't have enough. You may be leaving connections open accidentally and that's why they are all being eaten. Make sure you close every database connection as soon as you're done using it. You can also play with the Max Pool Size setting in your connection string. Here's more information: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp -- I hope this helps, Steve C. Orr, MCSD http://Steve.Orr.net "Andreas Klemt" <Click here to reveal e-mail address> wrote in message news:Click here to reveal e-mail address... [Original message clipped] Reply to this message... Vote that this is a GOOD answer... (1 vote from another user already)          Andreas Klemt GOOD ANSWER Many thanks, Steve for your fast reply! Regards, Andreas "Steve C. Orr, MCSD" <Click here to reveal e-mail address> schrieb im Newsbeitrag news:Click here to reveal e-mail address... [Original message clipped] l/cpconconnectionpoolingforsqlservernetdataprovider.asp [Original message clipped] Reply to this message... Vote that this is a GOOD answer... (1 vote from another user already)       System.Data.SqlClient.SqlConnection Ad BootFX Reliable and powerful .NET application framework. Recession Busting Bespoke Software Get through the recession by investing in bespoke software to decrease costs and create commercial opportunities. Other DN247 Network Sites .NET 247 SQL Server Wins Old Skool Developer

Copyright © AMX Software Ltd 2008-2009. Portions copyright © Matthew Baxter-Reynolds 2001-2009. All rights reserved. Contact Us - Terms of Use - Privacy Policy - .NET 247 is a member of the DN247 Network - 4.0.30129.1734