Use the RecordSet Close() method after using the Recordset object

A common way of accessing SQL Server databases from ASP pages is by using an ActiveX Directory Object (ADO) RecordSet object. When you have finished using the RecordSet object, you may encounter unexpected errors and decreased performance if you do not explicitly close the object.

Solution

For maximum performance and to avoid unexpected errors, call the Close() method when you no longer need to use the RecordSet object.

Copyright © 2005 Microsoft Corporation.
All rights reserved.