connection pooling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

we have a c# application (with SQL Server DB) which will run every half an
hour. we are using the connection with min pool = 5 and max pool=75. some
clients are giving the error that the pool is filled and no active connection
is available, though we are properly disposing the connection objects.

pls can anybody explain how the pooling of connections happen ?
 
I had same problem before.

The solution is to create connection only when you need it,
close it as soon as you finish use of it, do not keep it open for another use.
that's connection pooling's job.
also never call dispose() explicitiy in .net, GC takes care of it.
 
Back
Top