Techniques for enabling connection pooling - ADO.NET

Q.   What are the recommended techniques for enabling connection pooling on for a SQL Server 2000 or SQL Server 2005 database?

1. Setting the OLE DB Services connection string keyword to -4
2. Opening a connection and not explicitly disabling pooling
3. Setting the connection string keyword Pooling = True in the connection string
4. Using the Connection Pooling tab of the ODBC Data Source Administrator dialog
Box

- Published on 19 Oct 15

a. 1, 2
b. 1, 2, 3
c. 2, 3
d. 1, 4

ANSWER: 2, 3
 
For enabling connection pooling on for a SQL Server 2000 or SQL Server 2005 database set pooling = true and should not explicitly disable it.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲