This is a discussion on Interview Questions Feb 09, 2006 within the SQL Server forums, part of the Microsoft SQL Server category; --> What is Maximum Pool Size in ADO.NET Connection String? Maximum pool size decides the maximum number of connection objects ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| What is Maximum Pool Size in ADO.NET Connection String? Maximum pool size decides the maximum number of connection objects to be pooled. If the maximum pool size is reached and there is no usable connection available the request is queued until connections are released back in to pool. So it's always a good habit to either call the close or dispose method of the connection as soon as you have finished work with the connection object. How to enable and disable connection pooling? For .NET it's enabled by default but if you want to just make sure set Pooling=true in the connection string. To disable connection pooling set Pooling=false in connection string if it's a ADO.NET Connection. If it's an OLEDBConnection object set OLE DB Services=-4 in the connection string. Full Interview Questions for .NET and SQL Server http://www.geocities.com/dotnetinterviews/ Help the community to make job search easier mail your questions to jobatyourdoorstep@yahoo.co.in Looking for a onsite job mail your resumes at jobatyourdoorstep@yahoo.co.in |
| Thread Tools | |
| Display Modes | |
|
|