ADODB.Recordset error '800a0e78' - Operation is not allowed when the object is closed.

Hello,

I have an ASP VBScript web page that calls an MS SQL Stored Procedure, which queries the database..

When I test for values that I know don't exist I get --

ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/test23.asp, line 20

Where line 20 is --

if not RSContacts.eof then

Select allOpen in new window

Of -

<%
if(Request("search") <> "") then

Dim CMDContactSearch__search
CMDContactSearch__search = NULL
if(Request("search") <> "") then CMDContactSearch__search = Request("search")

set CMDContactSearch = Server.CreateObject("ADODB.Command")
CMDContactSearch.ActiveConnection = MM_GolfConnection_STRING
CMDContactSearch.CommandText = "dbo.ContactSearchv2"
CMDContactSearch.CommandType = 4
CMDContactSearch.CommandTimeout = 0
CMDContactSearch.Prepared = true
CMDContactSearch.Parameters.Append CMDContactSearch.CreateParameter("@RETURN_VALUE", 3, 4)
CMDContactSearch.Parameters.Append CMDContactSearch.CreateParameter("@search", 200, 1,500,CMDContactSearch__search)
set RSContacts = CMDContactSearch.Execute
RSContacts_numRows = 0

if not RSContacts.eof then
Dim ARRContacts
ARRContacts = RSContacts.GetRows()

RSContacts.Close()
Set RSContacts = Nothing

End if
End if
%>

Select allOpen in new window

I've tried changing the if statement to

if IsObject(RSContacts) then

Select allOpen in new window

but that just moves the problem --

ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/test23.asp, line 22

Line 22 is

ARRContacts = RSContacts.GetRows()

Select allOpen in new window

Help !!

What is the best route here?

Thanks