Keep getting the following error:

Results 1 to 2 of 2

Thread: Keep getting the following error:

  1. #1
    Join Date
    Dec 1969

    Default Keep getting the following error:

    Operation is not allowed when the object is closed. Line <BR><BR>Here is the script:<BR><BR><BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en claimsHistory<BR> <BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>Set rs.ActiveConnection = conn<BR>rs.CursorLocation = 3 &#039; Place before the .open<BR>rs.Open SQL<BR> <BR>&#039; Create a logic to determine if there are any records <BR><BR>&#039; ERRO IS OCCURING ON THIS LINE If rs.EOF Then<BR>If rs.EOF Then<BR>totRecords = "0"<BR>noRecords = "True"<BR>ELSE<BR>&#039; Create Record Count variable before converting rs into an array<BR>totRecords = rs.RecordCount <BR>&#039; convert the record set to an array <BR>noRecords = "False"<BR>NameRows = rs.getRows<BR>END IF<BR><BR><BR>Here is the line the error is occuring on:<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Well it looks ok

    check the rs.state....see if it is open<BR><BR>if that does not work try rs.Open SQL, conn, 3 instead of the way you have it<BR><BR>

Posting Permissions

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