DaniWeb Forum Index > Web Development > ASP

Operation is not allowed when the object is closed.

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2008

Posts: 4

Reputation: friendship.ani is an unknown quantity at this point

Solved Threads: 0

friendship.ani friendship.ani is offline

Offline

Newbie Poster

Operation is not allowed when the object is closed.

Jul 23rd, 2008

hi i m getting the error "Operation is not allowed when the object is closed".Why am i getting the error??Plz help

Code:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
Set rs_Temp= Server.CreateObject("ADODB.Recordset") 	
Set Cmd = Server.CreateObject("ADODB.Command")
   Cmd.ActiveConnection = lcn_Temp
    Cmd.CommandType = adCmdStoredProc
    Cmd.CommandText = "sp_temp"
Cmd.Parameters.Append Cmd.CreateParameter("@strCurrDate", adVarChar, adParamInput,100, CurrEndDate)
rs_Temp.CursorLocation = 3	
rs_Temp.Open Cmd
Set rs_Temp= Server.CreateObject("ADODB.Recordset") 	
Set Cmd = Server.CreateObject("ADODB.Command")
   Cmd.ActiveConnection = lcn_Temp
    Cmd.CommandType = adCmdStoredProc
    Cmd.CommandText = "sp_temp"
Cmd.Parameters.Append Cmd.CreateParameter("@strCurrDate", adVarChar, adParamInput,100, CurrEndDate)
rs_Temp.CursorLocation = 3	
rs_Temp.Open Cmd