I get error message when i try to execute SQL command. The message is "Cannot create new connection because in manual or distributed transaction mode". May i know why i get this message??<BR><BR>My SQL command is something like below:<BR><BR>update table1 where field = fieldInTable1<BR>update table2 where field = fieldInTable1<BR>select * from table2 where field = fieldInTable1<BR>do while rsTable2<BR> update table3 set status = inactive where field = fieldInTable2<BR><BR> select * from table3 where field=fieldInTable2<BR> do while rsTable3<BR> update table4 set status = inactive where field = fieldInTable3<BR> loop<BR>loop