I have a very big problem for me appears with a few steps when I use devart to connect to Oracle. Select on the following view in Oracle Code: create or replace view Test_View as select "ID","USR" from Test_Table@link_DB; ` Using LINQ CONNECT MODAL That's all, When I open the page the following exception will be shown (from the first time or after a postBack) distributed transaction already begun "ORA 02046 " Any help!

Reputation: 23841

Distributed transaction already begun "ORA 02046 " when I use Link

I have a very big problem for me appears with a few steps when I use devart to connect to Oracle.

Select on the following view in Oracle Code:

create or replace view Test_View as 
select "ID","USR" 
from Test_Table@link_DB; `

That's all, When I open the page the following exception will be shown (from the first time or after a postBack)

distributed transaction already begun "ORA 02046 "

Any help!

Upvotes: 2

Reputation: 121902

We have replied you at our forum here.
By the way, have you tried the solution recommended by @ThinkJet?

Upvotes: 1

Reputation: 6735

There is a problem with distributed transactions state on your Oracle database servers.

Try to rollback "in-doubt" distributed transaction as described here.

Step-by-step-guide located here.

Upvotes: 1