Microsoft KB Archive/286382

= PRB: Errors When You Open ADO Connection in Transactional Components =

Article ID: 286382

Article Last Modified on 12/5/2007

-

APPLIES TO


 * Microsoft COM+ 1.0
 * Microsoft COM+ 1.5
 * Microsoft Transaction Services 2.0
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.1 Service Pack 2
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.5 Service Pack 1
 * Microsoft Data Access Components 2.6

-



This article was previously published under Q286382



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you open an ActiveX Data Objects (ADO) connection from a transactional component in COM+, Microsoft Transaction Server (MTS), or any transactional Active Server Pages (ASP) page, you may receive the following error message if you use Microsoft OLE DB provider for Oracle:

Cannot connect to the transaction manager or the transaction manager is unavailable

If you use Microsoft Open Database Connectivity (ODBC) driver for Oracle under the same circumstances, you may receive the following error message:

Driver Not Capable

Note These error messages only occur when you open the ADO connection in transactional components. Non-transactional components work as expected.



RESOLUTION
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To resolve this problem, follow these steps:  Verify that the registry keys that pertain to the Oracle client libraries are set properly.For additional information about how to set these registry keys, click the article number below to view the article in the Microsoft Knowledge Base:

193893 INFO: Using Oracle with Microsoft Transaction Server and COM+

 Verify that the user has full control to the following registry keys:  On Microsoft Windows NT 4.0:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer

 On Microsoft Windows 2000:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI

 On both Windows NT 4.0 and Windows 2000:

HKEY_CLASSES_ROOT\CID

 </li></ol>

Keywords: kberrmsg kboracle kbprb KB286382

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.