Results 1 to 3 of 3

Thread: Problems Committing Transactions over db-links

  1. 10-26-2005, 07:25 AM #1
    tdahle
    tdahle is offline Registered User
    Join Date
    Oct 2005
    Location
    Norway
    Posts
    2

    Cool 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].
    Reply With Quote Reply With Quote
  2. 10-26-2005, 08:20 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check kb article 839279 to see if it's the case.
    Reply With Quote Reply With Quote
  3. 10-27-2005, 03:04 AM #3
    tdahle
    tdahle is offline Registered User
    Join Date
    Oct 2005
    Location
    Norway
    Posts
    2
    Quote 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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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