I have an ASP page that creates a SQL statement in on the fly and puts it in a string variable. I then fill a recordset with the following code:
set rst = conCRep.Execute(sql)
The recordset is filled with about 750 records, and there is only one field per record. At this point, I loop through the recordset as follows:
Do While Not rst.Eof
sql = "SELECT * FROM BankComp WHERE "
sql = sql & "Program = '" & rst("ProgramNumber") & "' AND EffectiveDate = '" &
EffDate & "'"
set rstTest = conCRep.Execute(sql)
The first time it tries to run the rstTest statement, I get the "Transaction context in use by another session." error. Any ideas what is going wrong? This only seems to happen when the initial SQL statement is returning a lot of records. For the record I am running SQL Server 2000.