Hi,<BR><BR>Can i use BeginTrans() method for one connection in a page where i have two<BR>different connections?<BR>Actually my code goes like this..<BR><BR>Here i am trying to insert data from a table of one connection to tables of<BR>another connection.<BR><BR><BR>set rs=conn1.execute(sql)<BR><BR>while rs.eof=false<BR> conn.begintrans<BR> .<BR> .<BR> .<BR> &#039Here i insert data in more than one table<BR> .<BR> .<BR> ..<BR> .<BR> if conn.errors.count &#062; 1 then<BR> conn.rollbacktrans<BR> else<BR> conn.committrans<BR> end if<BR><BR> rs.movenext<BR>wend<BR><BR>Now when i do this it gives the following error..<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039<BR><BR>You can&#039t have multiple recordsets with this cursor type (in a transaction.)<BR>Either change the cursor type, commit the transaction, or close one of the<BR>record sets.<BR><BR>Thx and regards<BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR ><BR>