ADO Close Method
Complete Record Object Reference
The Close method is used to close a Connection object, a Record object, a Recordset object, or a Stream object to free system resources.
Note: When an object is closed, it will not be removed from the memory. It is possible to change the property settings and open it again later.
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
%>
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
%>
Complete Record Object Reference
