ADO Close Method
Definition and Usage
The Close method is used to close a Connection object, Record object, Recordset object, or Stream object to release system resources.
Note:Closing an object does not delete it from memory; it can be reopened later after changing its property settings. To completely remove an object from memory, set the object variable to Nothing (in Visual Basic) after closing the object.
Syntax
object.Close
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
rs.Close
conn.Close
%>
