A connection pool is created for each unique connection string. So connections are added to the pool as needed, up to the maximum pool size specified (100 is the default).
Thanks for your reply, but still I was unable to find where exactly is the connection pool maintained - the client or the server side ??
Kind Regards,
Vikas
Kind Regards, Vikas
Hello again,
ADO.NET doesn't always create a connection pooling on the IIS server or SQL Server etc. even if you're connecting from a remote system. Typically, it creats pools on the system where the ADO.NET code runs. Please check this document for more detailed information
about .NET Connection Pool Lifegurad.
http://msdn.microsoft.com/en-us/library/aa175863(v=SQL.80).aspx