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?