Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
You may receive an error message when you use the Microsoft Oracle Managed Provider against an Oracle database
| Article ID | : | 952834 |
| Last Review | : | May 30, 2008 |
| Revision | : | 1.1 |
On This Page
SYMPTOMS
Consider the following scenario. You use the Microsoft Oracle Managed Provider 1.1 or the Microsoft Oracle Managed Provider 2.0 against an Oracle 8.
x database or against an Oracle 9.
x database. The Oracle 8.
x database is earlier than version 8.1.7.3.0. The Oracle 9.
x database is earlier than 9.0.1.3.0. In this scenario, you may receive one of the following error messages.
Error message 1
ORA-02041: client database did not begin a transaction
Error message 2
ORA-02074: cannot ROLLBACK in a distributed transaction
Error message 3
ORA-02074: cannot SET SAVEPOINT in a distributed transaction
Error message 4
ORA-02074: Cannot COMMIT in a distributed transaction
Error message 5
ORA-02074: cannot SET NLS in a distributed transaction
Back to the top
CAUSE
This problem occurs because of a known Oracle database issue.
Back to the top
RESOLUTION
To resolve this problem, use one of the following methods.
Back to the top
Method 1
Add the following property to the connection string for the Oracle database.
Workaround Oracle Bug 914652=true
Back to the top
Method 2
Update the Oracle 8.
x database to version 8.1.7.3.0 or to a later version. Or, update the Oracle 9.
x database to version 9.0.1.3.0 or to a later version.
Back to the top
APPLIES TO
| • | Microsoft .NET Framework 1.1 |
| • | Microsoft .NET Framework 2.0 |
Back to the top
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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
