Write results after close ADODB connection.
Do you happen to know if there is a way to keep on with the ADODB.Recordset instanciated after close its connection?
I'm question this as I have a large amount of data to write but I wouldn't like to keep the connection open after execute the SQL statement.
Please, let me know your thoughts.
Thanks in advance, Fernando
Re: Write results after close ADODB connection.
You could copy the record set to a Dictionary Object or an array