Error: Object is closed

[Eugene Anthony]

ASP code to delete a record:

openDB()

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
objConn.usp_del eteOptions OptionID,rs

closeRS()
closeDB()

MS SQL Stored Procedure:
create procedure usp_deleteOptio ns
@OptionID int
AS SET NOCOUNT ON

DELETE FROM Options WHERE OptionID=@Optio nID

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 ***

[Bob Barrows [MVP]]

Eugene Anthony wrote:

ASP code to delete a record:

openDB()

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
objConn.usp_del eteOptions 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_del eteOptions 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"