don't understand error

Page 1 of 3 123 LastLast
Results 1 to 10 of 29

Thread: don't understand error

  1. #1
    Join Date
    Dec 1969
    Posts
    862

    Default don't understand error

    ADODB.Connection error &#039;800a0e78&#039; <BR>Operation is not allowed when the object is closed. <BR>/clients_view_account.asp, line 13 <BR><BR>&#060;%<BR>Option Explicit<BR>Dim con, rst, strSQL, ad, i<BR>Set con = Server.CreateObject("ADODB.Connection")<BR>Set rst = Server.CreateObject("ADODB.Connection")<BR>strSQL = "SELECT * FROM tblTransactions WHERE dirCompanyID = &#039;" & _<BR>Session("ID") & "&#039; ORDER BY traDate;"<BR>con.Open "myDB"<BR>rst.Open strSQL, con, 3, 3<BR>i = 1<BR>%&#062;<BR>&#060;% =rst.RecordCount %&#062; &#039; this is line #13.<BR>...<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    18,177

    Default You never opened con. (eop)

    .

  3. #3
    Join Date
    Dec 1969
    Posts
    18,177

    Default I'm lying. (eop)

    .

  4. #4
    Join Date
    Dec 1969
    Posts
    18,177

    Default Check the EOF status..

    .. of RST.<BR><BR>And, check the Open property:<BR>&#060;%<BR>...<BR>rst.Open strSQL, con, 3, 3<BR>i = 1<BR>%&#062;<BR>State: &#060;%=rst.State %&#062;&#060;br /&#062;<BR>EOF: &#060;%=rst.EOF %&#062;&#060;br /&#062;<BR>&#060;% =rst.RecordCount %&#062; &#039; this is line #13.<BR>...<BR>


  5. #5
    Join Date
    Dec 1969
    Posts
    480

    Default RE: don't understand error

    Set rst = Server.CreateObject("ADODB.Recordset")

  6. #6
    Join Date
    Dec 1969
    Posts
    862

    Default fixed

    thx sholana

  7. #7
    Join Date
    Dec 1969
    Location
    Los Angeles, CA
    Posts
    21,192

    Default Getting worse and worse

    what all you had to do and never even got CLOSE to the answer<BR><BR><BR>

  8. #8
    Join Date
    Dec 1969
    Posts
    480

    Default Did I miss something?

    GOD!

  9. #9
    Join Date
    Dec 1969
    Posts
    18,177

    Default Getting dumb, in my old age.

    Completely overlooked that one.

  10. #10
    Join Date
    Dec 1969
    Location
    Los Angeles, CA
    Posts
    21,192

    Default Nope

    YOU did not<BR><BR><BR>someone else DID as usual<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
  •