Error: Object is closed
ASP code to delete a record:
Set rs = Server.CreateObject("ADODB.Recordset")
MS SQL Stored Procedure:
create procedure usp_deleteOptions
AS SET NOCOUNT ON
DELETE FROM Options WHERE OptionID=@OptionID
When I try to delete a record I get this error:
Operation is not allowed when the object is closed.
How do I solve the problem.
Your help is kindly appreciated.
*** Sent via Developersdex http://www.developersdex.com ***
Re: Error: Object is closed
Eugene Anthony wrote:
> ASP code to delete a record:
> Set rs = Server.CreateObject("ADODB.Recordset")
> objConn.usp_deleteOptions OptionID,rs
Why are you creating an expensive recordset to run a query/procedure that
does not return records??
Change the code to:
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
|All times are GMT. The time now is 02:37 PM.|
Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.