Post reply

Kind of Distributed transaction

  • December 24, 2004 at 7:14 am

    #183720

    Hello listers,

    First: I wish you all a merry christmas and a wonderfull 2005 year.

    Now here is my question:

    Does SQL Server 2005 (or even SQL Server 2000 since I know that SQL Server 7.0 does not support it) permit to have the following kind of distributed tranasaction:

    A distributed transaction that allow multiple client processes to participate in a transaction in a 3-tier environment.

    In order to do that a client process must get a reference to a distributed transaction and pass it to another process.

    Is it possible with SQL Server 2005 (or SQL 2000)?

    Maybe with ADO.NET 2.0?

    If yes... how.

    Thank's to all of you.

    Carl

     

  • December 27, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • January 11, 2005 at 9:42 am

    #536849

    Hello all,

    I saw that we can use Bound Connections to realise that.

    But the problem with that technique is that "Only one connection in a set of bound connections can be active at the any time."

    This is very limitating. Maybe this limitation will be solved with ADO.NET 2.0 since MARS (multiple Active result set) as been introduced. But maybe not.

    If someone as any input on that please post it.

    Best regards,

    Carl

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply