Database transactions.....

[Jimmy Crider]

I am using ADO.NET in my ASP.Net application(VB language).
Is it possible to implement transaction based SQL statements between
two different databases. One is SQL Server and the other one is Oracle.
Please advice.
Thanks

 

[Chad Z. Hower aka Kudzu]

I am using ADO.NET in my ASP.Net application(VB language).
Is it possible to implement transaction based SQL statements between
two different databases. One is SQL Server and the other one is Oracle.

I think you need MS Transaction server to do that.

 

[Rick Strahl [MVP]]

Hi Jimmy,

As Chad pointed out you'll need EnterpriseServices for that.

For components you can subclass from ServicedComponent and then use
distributed transaction management (SetAbort/SetComplete).

Actually ASP.Net provides integration with distributed Transaction
management in Page scope via the <%@ TRANSACTION> tag which allows
specifying that the page runs inside a distributed transaction. You can use
ContextUtil.SetAbort/SetComplete to commit or rollback.

+++ Rick ---

--

Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/weblog/