INFO: MDAC 2.1 Sets Session Pooling ON by Default (240166)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft OLE DB Provider for SQL Server 7.01
- Microsoft Data Access Components 1.5
- Microsoft Data Access Components 2.0
- Microsoft Data Access Components 2.1 SP2
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.7
This article was previously published under Q240166 SUMMARY
OLE DB resource pooling, also known as OLE DB session pooling, is handled by the OLE DB core components. To take advantage of resource pooling, an OLE DB consumer must invoke the data provider by using either the IDataInitialize or the IDBPromptInitialize interface. (ActiveX Data Objects [ADO] attempts to do this automatically). OLE DB resource pooling can be set ON for one provider and set OFF for another.
This article describes a behavioral change from MDAC 2.0 to MDAC 2.1. By default MDAC 2.0 sets session pooling OFF and MDAC 2.1 or later by default sets the session pooling ON.
REFERENCES
For more information, see the following:
Modification Type: | Major | Last Reviewed: | 12/5/2003 |
---|
Keywords: | kbinfo KB240166 |
---|
|