qaziasif
asked on
VB.NET and Oracle ora-02074
Hi ALL
I am trying to Call a Oracle (8.1.7) Stroed procedure from Vb.Net. The stored procedure has transaction. After sucessful completion of one Insert statement a record is inserted into a second table else rollback everyting. I am using OracleClient ( Dim OraClientCon As New OracleClient.OracleConnect ion). Whenever transaction rollback, I get ora-02074. I never initiated Distributed Transaction. From where it is comming from????
I have alternativly used OLEDB (Dim OleCon As New OleDb.OleDbConnection). I got the same result, but when I disabled Distributed Transaction by setting distribtx=0 in connectionstring, all gets well.
I am unable to find equilevant parameter for OracleClient. I have tried Enlist=False but no luck!!!
Please help.
I am trying to Call a Oracle (8.1.7) Stroed procedure from Vb.Net. The stored procedure has transaction. After sucessful completion of one Insert statement a record is inserted into a second table else rollback everyting. I am using OracleClient ( Dim OraClientCon As New OracleClient.OracleConnect
I have alternativly used OLEDB (Dim OleCon As New OleDb.OleDbConnection). I got the same result, but when I disabled Distributed Transaction by setting distribtx=0 in connectionstring, all gets well.
I am unable to find equilevant parameter for OracleClient. I have tried Enlist=False but no luck!!!
Please help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.