Name

ActiveConnection (Command, Recordset Objects) — Obj .ActiveConnection (= strConnectionName )

Synopsis

Indicates an open Connection object to which a Recordset or Command object belongs.

Parameters

Obj

A reference to a Command or Recordset object

strConnectionName

The name of a valid, open Connection object

Example

This example demonstrates how you set the ActiveConnection property of a Recordset object. To set the ActiveConnection property of a Command object, you would use exactly the same technique.

<%@ LANGUAGE="VBSCRIPT" %>
<% Response.Buffer = True %>
<HTML>
<HEAD>
<TITLE>ADO Examples</TITLE>
</HEAD>
<BODY>
<%
' Include ADOVBS.INC so we can use the ADO constants.
%>
<!-- #include virtual = "/MySSIncludes/adovbs.inc" -->
<%
' Instantiate an ADO Connection object.
Set objDBConn = Server.CreateObject("ADODB.Connection") 

' Construct the connection string for the Connection object.
strConn = _
   "driver={SQL Server};;uid=sa;pwd=;database=SalesDB"

' Using the connection string, open the connection.
objDBConn.Open strConn

' Instantiate an ADO Recordset object.
Set rsHighSales = _
                Server.CreateObject("ADODB.Recordset")
' Set the ActiveConnection property of the recordset.
rsHighSales.ActiveConnection = objDBConn ' Construct the SQL to be used to open the recordset. strSQL = _ "SELECT Buyer, Price FROM Sales WHERE Price > 70000" ' Open the recordset. Note the lack of a connection ' object specification. rsHighSales.Open strSQL %> First Buyer: <%=rsHighSales("Buyer")%><BR> First Price: ...

Get ASP in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial