Hello and welcome to our community! Is this your first visit?
Register
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
    Posts
    93
    Thanks
    3
    Thanked 0 Times in 0 Posts

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

    Hi, on this simple code
    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
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    26,184
    Thanks
    80
    Thanked 4,450 Times in 4,415 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)?
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

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