Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: MS DTC has stopped this transaction

    Hi all,

    I am new with Sql Server and going to use Link Server where I have to connect with a Postgresql Database.
    Everything is working fine.
    All the following queries are working:


    Code:
    SELECT a.*
    FROM openquery(PG,'select * from sports') as a
    
    INSERT OPENQUERY(PG,'SELECT ID FROM TESTTAB')
    VALUES(1)
    
    UPDATE OPENQUERY (PG, 'SELECT ID FROM TESTTAB') 
    SET id = 2;


    But when I use this DML statement in a trigger for a table, I get error:

    Code:
    Msg 8522, Level 18, State 1, Line 1
        Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.


    I enabled the "Enable XA Transaction" from googling.

    Any help please.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Pure guess, but does the user that is making the change (and launching the trigger) have permissions needed to use the PG linked server?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •