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