Operation not allowed

Posted on 2005-04-11
Last Modified: 2010-05-18
I generate this error from the code below.
Can anyone tell me what I did wrong?

ADODB.Recordset error '800a0c93'
Operation is not allowed in this context.
/Help/request.asp, line 48

      SET rs = Server.CreateObject("ADODB.Recordset")
   "tblHD_Request", conn, 3, 3
            rs("Request_type_ID") = FORM_HIDDEN
            rs("Requestor_ID") = hd_request_id
            rs("Requestor_Date") = FORM_DATE
            rs("Requestor_request") = FORM_DESCRIPTION
            hd_request_id = rs("HD_Request_ID")
            rs.Close      <--- Line 48
            Set rs = Nothing
Question by:Isaac
    1 Comment
    LVL 5

    Accepted Solution

    It should have rs.update then rs.close.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
    I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now