-
Problems Committing Transactions over db-links
I have a problem with copying data over a db-link. When running the transaction in Query Analyzer it works fine, but when running it via a package, I get the following error-message. Has anyone a solution to this problem ???
Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
-
Check kb article 839279 to see if it's the case.
-
Originally Posted by rmiao
Check kb article 839279 to see if it's the case.
It looks promissing, but I will not have time to try the work-around until next week. Thanks a lot.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|