Microsoft Knowledge Base Email Alertz

(245267) - 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.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 245267 - Last Review: October 17, 2003 - Revision: 2.0

DOC: "OLEDB_SERVICES = -2" Does Not Disable Autoenlistment

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:

Collapse this tableExpand this table
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:

Collapse this tableExpand this table
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.

APPLIES TO
  • Microsoft OLE DB Provider for ODBC 2.0
  • Microsoft Data Access Components Software Development Kit 2.0
Keywords: 
kbdocfix kbinfo kbmdacnosweep KB245267
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate