Home > DeveloperSection > Forums > maxpool error in the application
Rajesh Goswami

Total Post:29

Points:203
Posted on    December-15-2010 8:27 AM

 ASP.Net ASP.Net 
Ratings:


 1 Reply(s)
 1139  View(s)
Rate this:
maxpool error in the application how remove it?


Amit Singh

Total Post:103

Points:721
Posted on    December-15-2010 8:30 AM

You can clear the pool use the following code. However i suggest you to check the following first
1. Please call the Dispose() method after you close the connection.

2. Ask the DBA to check for open connections at the very moment you are greeted with the error. You could find the faulty application.

3. Check the web.config for the pool settings. Set pooling to true.

Max Pool Size - Leave it at 100

Min Pool Size - Mark it 0

Pooling - Mark to true

4. Note: Restarting the IIS could fix the issue. Because the AppPools would refresh. If all does not work, then do this.

 //To clear the specific connection

SqlConnection.ClearPool(SqlConnection conn)

 //To clear all pools

SqlConnection.ClearAllPools()


Don't want to miss updates? Please click the below button!

Follow MindStick