operation not allowed when the object is closed when running more advanced query
This is a common problem caused by row counts being interpreted as output from a Stored Procedure when using ADODB with SQL Server. To avoid this remember to set SET NOCOUNT ON; in your Stored Procedure this will stop ADODB returning a closed recordset, or if for whatever reason you don’t want to do this … Read more