ADO ActiveConnection Property

Definition and Usage

The ActiveConnection property can indicate the Connection object currently owned by the Command object.

The ActiveConnection property can indicate the Connection object currently owned by the Command object. If the connection is closed, it can set or return the definition of the connection. If the connection is open, it will set or return the current Connection object.

Syntax

objcommand.ActiveConnection

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set comm=Server.CreateObject("ADODB.Command")
comm.ActiveConnection=conn
response.write(comm.ActiveConnection)
conn.close
%>