Need ASP help quick!

[grrreg]

I am getting the following error
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
/ASPSAMPLE3/ASP Page1.asp, line 44

I am trying to pass the name of a stored proc into another store proc and it will be called from within there. I tried this commenting out only the proc name variable and it works fine. What the heck does that error mean?? ANYONE???

Here is a chunk of the code

Set Comm = Server.CreateObject("ADODB.Command")
Set Comm.ActiveConnection = objDC
Comm.commandtype=4

Comm.commandtext = "_Proc_Tunnel"

Comm.Parameters("@Function") = "_Proc_FERecords"
Comm.Parameters("@Action") = "RETRIEVEMENU*"
Comm.Parameters("@Menu_Id") = -1
Comm.Parameters("@Fid") = 0
Comm.Parameters("@Language_Code") = 044
Comm.Parameters("@User_Id") = "TS"
Comm.Parameters("@User_Uid") = 14
Comm.Parameters("@Popup") = ""
Comm.Parameters("@Product_Code") = "DESIGN"
Comm.Parameters("@Period") = "LIVE"

Set objRS = Comm.execute()

[Johnny101]

this is silly, but the objDC has been opened - right? that error means something has been called on a closed object - either a check for EOF on a closed recordset, or an execute on a closed connection. something like that.

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

[jgauntz]

Where in your code are you getting the error. Is it on the execute of the command object ??? where ????