SQL Server and cursors

[transparent]

I keep getting the error: 'Rowset position cannot be restarted '
when executing a stored procedure. However when run using query analyser it returns a row. My asp code reads:

set obj_RSet = server.createobject("ADODB.recordset&quot

with obj_Comm

.ActiveConnection = obj_Conn
.CommandText = "usp_news_main_by_user_admin"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@Page",adInteger,adParamInput,2,int_page)
.Parameters.Append .CreateParameter("@RecsPerPage",adInteger,adParamInput,2,4)
.Parameters.Append .CreateParameter("@user_id",adInteger,adParamInput,2,session("admin_id&quot)

end with


obj_RSet.open obj_Comm, ,adOpenKeyset

if not obj_RSet.EOF then ........

Any ideas why this is a problem?

Cheers