Configure connection pool for SQL Server OleDB provider

[feng]

Hi,

I need to configure connection pooling for SQL Server
OleDB provider. Although the ".Net Data Access
Architecture Guide"
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnbda/html/daag.asp) says that, with
the SQL Server OleDB provider, "You can use the connection
string to configure, enable, or disable resource pooling",
but it never tells how and no doc can be found anywhere.

Can someone tell me if the statement from the above is
true or false? Is is really possible to configure the Max
size and Min size of the connection pool using connection
string? If this is actually not possible, what is the
alternative? and how to do it?

Thanks a million!

 

[M. Zeeshan Mustafa]

Feng,

Thats right, you can configure connection pooling from
connection string.

Check this link for reference:
http://msdn.microsoft.com/library/e...ntSqlConnectionClassConnectionStringTopic.asp

an example could be..

Server=localhost;Database=Pubs;Trusted_Connection=True;Connection
Timeout=60;Pooling=True;Min Pool Size=1;Max Pool Size=10

 

[Angel Saenz-Badillos[MS]]

feng,

Not exactly, the information below only applies to the SqlClient provider.
The Oledb provider is only a wrapper for a native provider and you should
look at the documentation for the specific native provider you are using.

If you are using the native sqloledb provider you can turn off pooling using
the Oledb Services registry keys
Registry Key OLEDB_SERVICES, when it is:
-1 All services are on, including Connection Pooling.(default)
-4 Turns off Connection Pooling and Automatic distributed transaction
enlistment.
There are other settings you might want to consult the OleDb manual.

Without going to the registry you can turn off Connection Pooling by using
the connection string keyword "OLE DB Services=-4"