ADO Transaction and MTS Transaction

<i><b>Originally posted by : Pan (panyb@163.net)</b></i><br />When I use ADO BeginTrans and CommitTrans and RollBackTrans to manage the transaction.The transaction do not work ,but When I use MTS transaction , it worked .How to use MTS transaction and ADO transaction?<br /><br />This is the sample i use.(column code is Table1's Primary Key)<br /><br />ADO( two row inserted )<br /><br /><%<br />set Conn = Server.CreateObject( "ADODB.CONNECTION" )<br />Conn.Open "FILEDSN=mb_approval.dsn"<br /><br />call Conn.BeginTrans<br /><br />call Conn.Execute( "insert into Table1(code) values('aa')" )<br />call Conn.Execute( "insert into Table1(code) values('aa')" )<br />call Conn.Execute( "insert into Table1(code) values('ab')" )<br /><br />if Conn.Errors.Count > 0 then<br /> Conn.RollbackTrans<br />else<br /> Conn.CommitTrans<br />End if<br />%><br /><br /><br />MTS ( No row inserted)<br /><br /><%@ Transaction=Requried%><br /><%<br />call Conn.Execute( "insert into Table1(code) values('aa')" )<br />call Conn.Execute( "insert into Table1(code) values('aa')" )<br />call Conn.Execute( "insert into Table1(code) values('ab')" )<br />%><br /><br />