ORA-02074: cannot ROLLBACK in a distributed transaction - HELP?

[TWillard]

I am executing a stored procedure from an ASP page. Due to bad data issues, I am getting the following error on occasion:

ORA-02074: cannot ROLLBACK in a distributed transaction

I am working to clean up the current data issues. However, I need to understand this error, so that I can be sure that it will not happen again. Can someone please explain this error? Can I just simply not use rollback statements in my procedure, if it is being called via ADODB?

I am ususally in the ASP, HTML, JavaScript forums, so I hope that I have explained my error clearly. Thank you in advanced for reading my questions.

 

[TWillard]

I think I found the answer to my question. You must place the following in your connection string:

distribtx=0

for example:

set dataconn = server.createobject ("ADODB.connection&quot
dataconn.open="Provider=OraOLEDB.Oracle;User ID=userid;Password=pass;Data Source=source;DistribTX=0"

This was a beast to research. There was no clear documentation on how to fix this anywhere. But anyway.. it works.. I hope this helps someonelse.