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
%>

Complete Record Object Reference

Altova® MissionKit® - Integrated suite of XML tools

The Altova MissionKit is a suite of intelligent XML tools, including:

XMLSpy® – industry-leading XML editor

• Support for all XML-based technologies
• Graphical editing views, powerful debuggers, code generation, & more

MapForce® – graphical data mapping tool

• Drag-and-drop data conversion with code generation
• Support for XML, DBs, EDI, Excel® 2007, text, Web services

StyleVision® – visual stylesheet designer

• Drag-and-drop stylesheet design for XML & databases
• Output to HTML, PDF, RTF, Word 2007, & more

And more…

Try before you buy with a free fully functional 30-day trial

Download today