DOC: "OLEDB_SERVICES = -2" Does Not Disable Autoenlistment (245267)



The information in this article applies to:

  • Microsoft OLE DB Provider for ODBC 2.0
  • Microsoft Data Access SDK 2.0

This article was previously published under Q245267

SUMMARY

The "OLE DB 2.0 Readme" (olreadme.txt) file in the Microsoft Data Access SDK version 2.0 states that:

"OLEDB_SERVICES = -2" disables OLE DB resource pooling and autoenlistment."

Pooling is disabled, but not autoenlistment.

MORE INFORMATION

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

In the Microsoft Data Access SDK version 2.0 documentation you find the following paragraph: 4.4.5.1 Enabling/Disabling Services for a Provider

Individual OLE DB services can be enabled or disabled by default for all applications that access a single provider. This is done by adding an OLEDB_SERVICES registry entry under the provider's CLSID, with a DWORD value specifying the services to enable or disable as follows:

Default Services EnabledKeyword Value
All services (the default)0xffffffff
All except Pooling and AutoEnlistment0xfffffffe
All except Client Cursor 0xfffffffb
All except pooling, enlistment, and cursor0xfffffff0
No services0x00000000
No aggregation, all services disabled[missing key]
This information is not completely correct. It should read:

Default Services EnabledKeyword Value
All services (the default)0xffffffff = -1
All except Pooling0xfffffffe = -2
All except Pooling and AutoEnlistment0xfffffffc = -4
All except Client Cursor0xfffffffb = -5
All except pooling, enlistment, and cursor0xfffffff8 = -8
No services0x00000000
No aggregation, all services disabled[missing key]


The same values are true for the paragraph "4.4.5.2 Overriding Provider Service Defaults".

If you disable pooling you should always disable autoenlistment as well.

Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbdocfix kbinfo kbMDACNoSweep KB245267