Hi,<BR> v r using a middle tier to connect and do transaction with database. to day i have faced problem with some asp file to check it i have changed that ASP files transaction which are with that componet. to direct ADO conn, Recordset.<BR><BR>I am getting the below error at the second inline query. but if i remove <BR> Transaction="Requires_New"<BR>from the first line of the file it is working fine. can u pl helpme <BR><BR>why and where this occers<BR><BR>"Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets"