April 28, 2005 at 12:36 pm
I am trying to insert into sql table by running a stored procedure against oracle database via a linked server. I can query the oracle database fine, but I have not been able to insert any rows into sql server with data from oracle. The error that I keep on getting is:
Server: Msg 7391, Level 16, State 1, Procedure GET_ORACLEDATA, Line 4
The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].
Thanks
April 28, 2005 at 12:56 pm
1. Make sure Distributed Transaction Coordinator (DTC or MSDTC) on all servers that are involved in the distributed transaction are started.
2. Check the return value of the system function @@SERVERNAME on both servers. Verify whether the return value matches the computer name of each server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106
April 28, 2005 at 1:19 pm
Another thing to check is as to, if you are running Windows 2003, that you have remote distributed transactions enabled. http://www.kbalertz.com/Feedback_329332.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply