Add interactive features to your site

How do I add interactive features to your site (TRANSACTION)?



IIS (Internet Information Server) is closely matched with MTS (Mircrosoft Transaction server)

Together, the database changes have "die and die" interaction (TRANSACTION) function.



Success occurs when all the database changes in the ASP program are successful, and when a change to a database fails,

The changed database data will be automatically restored (rollback), which is called Interactive (TRANSACTION) functionality.



For example, from a account remittance to B account, if the B account of the database changes failed, has changed the database of a account

The data will be automatically restored. The data of multiple databases is not "same life" or "total death".



Not all databases provide interactive functionality, such as access is not provided, and SQL Server and Oracle provide

Interactive function.



The effective scope of interactive function in ASP program is an ASP program, that is, all the data involved in this ASP program

Library changes have an interactive function.



How do you tell IIS to interact in an ASP program?



method to add "transaction=required" to the first line of the ASP program and tell IIS that the ASP program uses interactive

The function of the processing method, ASP program is as follows:


<%@ transaction=required language= "VBScript"% >

...

<% Set Obj1 = Server.CreateObject ("testobj.cls1")% >

<% = obj1.data3t (1,10)% >

<%

Sub OnTransactionCommit ()

....

End Sub


Sub OnTransactionAbort ()

....

End Sub

% >