Steve,
Let us say I have all my database operations code in one page and all the
database activity is with only one database, then page directive Transaction
set to transaction mode will work fine.
I checked with inserting with two tables one getting failed, it works just
fine. Hopefully it works with delete/update cross different sql statements.
Not tested with connection to different databases especially to Oracle.
What is your suggestion.
Veer
"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:u2**************@TK2MSFTNGP09.phx.gbl...
You need a distributed transaction.
Here's more info:
http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpcondistributedtransactions.asp
http://msdn.microsoft.com/library/de...us/dndotnet/ht
ml/disttranvbnet.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Veeresh" <Ve******@hotmail.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl... I have couple of SQL insert statements spread across SQL Server and
Oracle database and legacy system. All these multiple insert statements
(multiple insert with in SQL and other databases) are written in the same page but
spread across different functions and sub procedures. How to make all
these insert statements as transaction based statements?
Veer