Why I get ADODB.Recordset error '800a0e78'

[n.huda]

I have a query that is tested, and I am trying to get the data by executing it.
The connection is tested and working for other queries on the same page.
Yet - when trying to execute it - I get "ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed."

I searched for this error and did not find any solution.
The only thing I want to mention here is - in the query, I have some variable declaration, then a temp table declaration and insertion in that. And finally the main query. Having multiple statements should not be a problem, should it?

Thanks.

[Doug G]

One guess, if you have any 'on error resume next' statement try removing it. When on error resume next is active it will hide asp error messages, perhaps you have some other coding error that is preventing your recordset object from opening.

[webber123456]

we can't really help unless you post the problem code.

but it is likely just what the error message says: closed object. Make sure you open the recordset object before trying to use it.

    Dim oConn, oRs: 
    Set oConn =  CreateObject("ADODB.Connection")    
    Set oRs = CreateObject("ADODB.Recordset")
 
    '// OPEN THE CONNECTION OBJECT
    '-----------------------------------------
    With oConn
        If .State = adStateOpen Then .Close
        .ConnectionString = MY_CONNECTION_STRING
        .open
    End With

[n.huda]

Thanks Doug and Webber. I removed the variable declaration, the temp table insertion etc. that was there before the main select, instead - using the parameters directly in the select. Then it started working.