ADO Recordset shows BOF and EOF true / Query Analyser does not agreee
Posted on 2003-12-03
SQL Server 2000
ADO 2.6 from ASP
From an ASP we run a SP that returns multiple RSs, using NextRecordset to move from one to the next. The final RS looks to be empty to ADO - the BOF and EOF properties are true. However, the same SP, when run through Query Analyser, shows what we know to be true - the final RS DOES contain records.
What can be going on here?
How is the driver getting spooked (if that's the case)?
Not that it should matter, but the final RS is being pulled from a temporary table.