Hi @.ll,
we have right now big problemes with our replication and linked servers to
oracle.
has anybody an idea what wrong?
if we use a select statement everything works fine, only if we use a update
statement on a table on the SQL Server we see the error.
Just for your info. we use JOIN over 2 tbl on the Linked Server Side.
the error message is :
Server: Msg 7391, Level 16, State 1, Line 1
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 0x8000d048
thanks
klaus
Klaus,
apart from the obvious check - is MSDTC started - have a look at these
articles which are designed to troubleshoot this error:
http://support.microsoft.com/default.aspx?kbid=306212
http://support.microsoft.com/kb/280106/EN-US/
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||http://support.microsoft.com/default...;en-us;Q280106
does this help.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
No comments:
Post a Comment