Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Mar 2006
    Thanked 0 Times in 0 Posts

    sometimes having operation is not allowed when the object is closed error

    Hi, on this simple code
    SQLRedirect= "SELECT * FROM elementsOutils WHERE id=" & id
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open SQLRedirect,Conn
    I'm having operation is not allowed when the object is closed errors but not all time. It seems to happen when alot of users are opening pages at the same time. users are trying again a couple of seconds later and it's working.

    Is it something on the server?

    I'm using an access database

  2. #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Thanked 4,947 Times in 4,908 Posts
    Yes, of course it is on server, as that code will not be impacted by what browser is in use.

    I don't think we can diagnose the problem from that small fragment of code.

    Are you sure that the error is coming from the rs.Open line and not from the next line (that you don't show)?
    Be yourself. No one else is as qualified.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts