Connection Pooling Issues

Hot Topic

.NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7C812A5B) (800703e9) while starting Visual Studio 2005 IDE
A Cosmetic Question
Bad Variable exception, when using an ActiveX on WinForm as a seperate Thread.
Filling a ComboBox with DataSet filed contents
.Net 2.0 Interop with .Net 1.1, VB6, ASP clients
Formatting numbers
Can you pls Demystify Debug.Assert, Debug.Write and Trace.Assert for me
Passing user32.dll GetDC() IntPtr value from C# into C++?
How to run a Asp.net 2.0 and 1.3 application....
In C#, what is the difference between System.String and System.string (lowercase)

.NET Development

Copying Files useing C#
Is .NET 2.0 required to run a Visual Studio C++ unmanaged Application?
Xml and the dreaded ampersand character
Suspended thread uses 100% CPU in debug mode
Publishing problem
MySql - Doubt
How do i update table with ID's from user input?
maybe i can't?
Is there a way to get list of all colors?
Excel and ODBC

Connection Pooling Issues

I've been getting an error that goes something like 'Cannot obtain a connection from the pool, maximum pool size has been reached' I had been using a max pool size of 300, and now i've increased to 10,000. Is this the right thing to do Is there a limit to the pool size that i can set So far i haven't had that error, but I would like to know if there is a better way to handle the issue

Thanks

Emeka Awagu

Answer this question

Connection Pooling Issues

  • James Mayer

    Note this error is quite common and it indicates that somewhere in your code you are not closing a connection. Finding out where is the tricky part!

  • Keith Newton

    Yes i believe my application is closing the connection - all my data access codes are enclosed within a try..catch..finally block. and i always close the connection in the finally block.

    I'm working with Microsoft SQL Server 2000

    Thank you.

  • IntMain


    Is your application explicitly closing the connection when it has finished using it What type of database are you working with

  • Connection Pooling Issues
Answer this question