Database transactions.....

  • Thread starter Thread starter Jimmy Crider
  • Start date Start date
J

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
 
Jimmy Crider said:
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.
Click to expand...

I think you need MS Transaction server to do that.
 
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/
 
Back
Top