
MTS, ASP Pages and Transactions
I have a COM DLL in which the classes have an "MTS Transaction Mode" of
"Requires Transactions". These classes are called from ASP pages. In a
particular ASP page, I make several *separate* calls to functions in the COM
DLL that inserts and/or updates records. I understand that each of these
calls is treated as a separate transaction and will commit or rollback
Required %>" directive at the top of the ASP page, will all my separate COM
calls/transactions be treated as a single transaction? For example, assume
my ASP page makes the following COM calls:
1) InsertRecord_1(): This function commits successfully
(Context.SetComplete is called in the COM function)
2) InsertRecord_2(): This COM function commits successfully
(Context.SetComplete is called in the COM function)
3) UpdateRecord_3(): This COM function commits successfully
(Context.SetComplete is called in the COM function)
4) InsertRecord_4(): This COM function aborts (Context.SetAbort is called in
the COM function)
Will the failing of InsertRecord_4() cause the first three
functions/transactions to rollback?
Thanks very much.
Randy