Pankaj G

Pankaj G

  • NA
  • 3
  • 0

Distributed Transaction implementation problem

Jan 10 2006 3:46 AM

I am implementing the Distributed transaction in .NET 2.0 (using ASP.NET + ADO.NET). I have 3 machines:

Web Server: Win Xp Prof with SP2 and .NET2.0 (Machine 1)
Database A: SQL 2000 with SP4 on Win 2k3 SP1 (Machine 2)
Database B: SQL 2000 with SP4 on Win 2k3 SP1 (Machine 3) 

Note: Can I have web server’s OS as Win XP Prof for Distributed Transaction?

Transaction code is implemented in one of the ASP.NET page on Web Server. I am trying to implement the Distributed Transaction with database A and B. But error we are receiving:

The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)

Code written in ASP.NET application for Transaction.

using (System.Transactions.TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)){
          // Call Insert on database A using ADO.NET
         // Call Insert on database B using ADO.NET
}

All suggestions are welcome!

Thanks in advance.
Pankaj