OLE DB .NET Data Provider
The OLE DB .NET data provider pools connections by using the underlying services of OLE DB resource pooling. This is essentially the same thing, just worded differently. You will be able to use the connection string to configure, enable, or disable resource pooling (connection pooling), use the registry to configure OLE DB resource pooling (not recommended), and programmatically configure resource pooling. OK, so if you want to disable OLE DB .NET connection pooling and use the COM+ object pooling, you will have to supply a connection string keyword that turns it off (OLE DB Services=-4) because it is “on” as the default. The connection would look like this:
Dim nwindConn As OleDbConnection = New OleDBConnection ("Provider=SQLOLEDB;OLE ...Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
