I have stored procedure with couple input parameters (MS SQL) which creates temporary table and returns recordset as the result from that tamporary table. Stored procedure works ok on its own.
I need to get that recordset in ASP but it doesn't work !?!

Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = Conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "PROC_DrawingTest"

cmd.Parameters.Append(cmd.CreateParameter("jobno", adVarChar, adParamInput, 20, Session("JobNumber")))
cmd.Parameters.Append(cmd.CreateParameter("strdwgs ", adVarChar, adParamInput, 1000, sqlstr))

Set rec = cmd.Execute()

If not rec.EOF then
- here I have an error

Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.

Please, help!