RE: Cannot Rollback In a Distributed Transaction

From: Jining Han <jining_han_at_MailAndNews.com>
Date: Tue, 13 Feb 2001 09:20:57 -0500
Message-ID: <3A91EDDE@MailAndNews.com>

You need to set DistribTX property to 0 in LOCAL_MACHINE\SOFTWARE\Oracle\OLEDB.

Good luck

---

Jining Han
Sallie Mae

>===== Original Message From hpadmaso_at_bellatlantic.net (Harish Padmasola)

---

>Here's the scenario.
>
>Iam using VB ,connecting to a oracle database using oracle's OLEDB
>PRovider. Everything works fine. Iam able to call stored procedures
>and all those good things.
>
>The Problem :
> When my stored Procedure in Oracle errors, It does a rollback and
>the procedure (actually its a function) returns a -1. The problem is
>its not doing the rollback. and I get the following Error msg :
>
>"Rollback cannot be performed in a distributed Transaction."
>
>When I run the procedure in SQLPLUS , It seems to rollback fine .
>
>
>Any solutions is greatly appreciated.
>
>Thnx
>Harish
>

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Tue Feb 13 2001 - 08:20:57 CST