Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 oracledb error

Author  Topic 

preethiLeela
Starting Member

5 Posts

Posted - 2014-09-17 : 02:26:22
Distrubuted transaction is not allowed in linked server.

while i try for the following thing

Ex:begin distributed transaction

select * from openquery (oracledb,'select * from sm40_cus')

end

the above query returns following error
error:
Oracle" for linked server "OracleDB" returned message "New transaction cannot enlist in the specified transaction coordinator. "


need help

preethi

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-09-17 : 07:03:09
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196173
Go to Top of Page
   

- Advertisement -