hmm... Iam still getting the same error even after I Set DistribTX
property in the registry to a 0. Is there anything else Iam missing
??
thnx,
Harish
On Tue, 13 Feb 2001 09:20:57 -0500, Jining Han
<jining_han_at_MailAndNews.com> wrote:
>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 Wed Feb 14 2001 - 06:14:49 CST