Error: Object is closed
 

ASP code to delete a record:

openDB()

Set rs = Server.CreateObject("ADODB.Recordset")
objConn.usp_deleteOptions OptionID,rs

closeRS()
closeDB()



MS SQL Stored Procedure:


create procedure usp_deleteOptions
@OptionID int
AS SET NOCOUNT ON

DELETE FROM Options WHERE OptionID=@OptionID

Return
GO



Problem:

When I try to delete a record I get this error:

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


How do I solve the problem.


Your help is kindly appreciated.


Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***

Re: Error: Object is closed
 

Eugene Anthony wrote:
> ASP code to delete a record:
>
> openDB()
>
> Set rs = Server.CreateObject("ADODB.Recordset")
> objConn.usp_deleteOptions OptionID,rs
>
> closeRS()
> closeDB()
>

>
>
Why are you creating an expensive recordset to run a query/procedure that
does not return records??
Change the code to:
openDB()

objConn.usp_deleteOptions OptionID

closeRS()
closeDB()



--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"