I am working in classic asp with vbscript.
I am looking for a solution for an error for long time.So i ll post my query.
In my ASP page , I am populating a record set from SQL SERVER stored procedure.
As soon as the record set is populating , i am checking whether it is null or not.
For that , I added


If (RSDataset.EOF) Then
Response.Write("RecordSet in empty")
Else
Response.Write("Record(s) are in the RecordSet")
End If
Response.End

When the stored procedure returning data it display 'Record(s) are in the RecordSet'.
When the stored procedure not returning data(ie no rows) it display 'RecordSet in empty'


But for some cases it is displaying the error


ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

DataCheckPage.asp, line 35

By googling I came to no that , adding SET NO COUNT ON is a solution.That I already added.
An the Connection is not closed, as I checked that also.

Can anyone help me out to resolve this ?