locked
WCF-Custom, SQL Binding, Ambient Transaction = true, does not work RRS feed

  • Question

  • Hi,

    I have  a receive location retrieving data from SQL . Adapter - WCF Custom with Sql Binding

    Poll Data available statement  -  in a Stored procedure

    SELECT count(*)fromTableName whereStatus=0

    Polling Statement -  in a Stored procedure


    DECLARE
    @count int;
    BEGIN
    SET NOCOUNT ON;
    SET @count = (SELECT COUNT(*) FROM TableName where Status = 0);
    IF @count > 0
    BEGIN
    update top (1) TableName set Status = 9 where Status = 0
    select * from TableName where Status = 9 for xml auto
    update TableName set Status = 1 where Status = 9
    END
    END

    If I set the Ambient Transaction to false, it works ok.

    But, when ambient transaction = True, no results are returned.

    MSDTC is enabled on both BizTalk and SQL Server.

    Any help is appreciated.

    Regards,

    Wednesday, April 17, 2019 9:23 AM

All replies