| Trouble with ORA-02074: cannot Rollback. [message #62801] |
Mon, 16 August 2004 02:43 |
Juergen
Messages: 7
Registered: August 2002
|
Junior Member |
|
|
Hi,
I have a lot of trouble with the "ORA-02074: cannot Rollback in a distributed transaction" error message on our Oracle 8 server when acessing using ODBC or OleDB drivers.
I have set the "Disable MTS support" and "distribtx=0" options and most of the time the rollback works. But every (exactly) 5 minutes, Rollback fails with this error. I definitely have no distributed transaction and I've tried around with all combinations of "pragma autonomous_transaction" without avail.
Any help with this?
Regards,
Juergen
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
