Ora-02041

[Srinivas_Sharma]

Hello

I m using Web Services using .net, Our backend is an Oracle 8i database.

When i try to get some info over a dblink using a .net as front end, i get ORA-02041 error.

when i looked for it i got the below desc

ORA-02041 client database did not begin a transaction

Cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.


and i was told that i should include DistribTX=0 in the connection settings if i m using a OLEDB provider.

I m using ODP.NET provider and it does not have any affect when i include DistribTX=0 in the connection string.

Any help appreciated here.

Thanks

SS

[balajiyes]

HTH

ORA-02041 client database did not begin a transaction

Cause: An update occurred at a coordinated database without the coordinator
beginning a distributed transaction. This may happen if a stored procedure
commits and then performs updates, and the stored procedure is invoked
remotely. It could also happen if an external transaction monitor violates the XA
protocol.

Action: If the cause is the former, check that any commit is not followed by an
update.

[Srinivas_Sharma]

Hi,

I do have the info which u have said,

Whats the solution for it...we r not doing any updates, we r just performing Selects over a db link.

SS