I have a SP.
When I run it I get dataset , no errors.
Now I call this Sp from ASP

Set Rs = Cm.Execute
response.write "Rs(0)=" & Rs.Fields(0).Value

But when run the code I get this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

Looks like Rs was not populated.
How do I test if Rs was pumped with records?

If Not (Rs.BOF And Rs.EOF) Then
   'Records returned
Else
   'No records returned
End If

Peter
-------------------------
Work smarter, not harder

That's exactly what I have:
If Not (Rs.BOF And Rs.EOF) Then

And the error occurs at this line - If Not (Rs.BOF And Rs.EOF) Then

Actually the exact error is:
ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

Hi there,

It looks like the recordset is closed, and not necessarily empty. Even on a "full" but closed recordset, you cannot use these kind of methods and properties.

How does the sproc look like? Are you sure it's returning any records and are you sure it performs a valid SELECT statement? Are you suppressing the "Records Affected" message?

To try that out, try this:

MySecondRecordSet = Rs.NextRecordSet()

If Not MySecondRecordSet.EOF Then
Response.Write("Not EOF")
End If

If this code runs fine, you'll need to suppress the messages that SQL Server generates using SET NOCOUNT ON

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.