Content


    Connection Object
 Syntax
   
        Parameters
 Methods
 Properties
 Events
 Remarks

Connection Object

Connection object of ActiveX Data Object component is related to manipulate the connection session with a data source. The Connection Object should be created by a Server.CreateObject Method such that the Web server can make a connection with a data source.

Although an instance of the Connection object of the ADODB Library has higher hierarchical relationship with other ADO objects in the ADODB Library, ADO objects can also be created outside the scope of the ADO hierarchy. When a Recordset or Command object is created, it is not necessary to create a connection first, because the Recordset or Command object is just a place holder. When a Recordset or Command object is opened, it is also not necessary to create a connection first, because a Connection object is automatically created behind the scenes according to the specified ConnectionString in the line of code.

Syntax

Set ConnName = Server.CreateObject("ADODB.Connection")

Parameters

ConnName

The parameter "ConnName" is the name assigned to the instance of the Connection object of the ADODB Library created by the call using the Server.CreateObject.

ADODB.Connection

The parameter "ADODB.Connection" is used to specified the name of the type of ADO DataBase object included in the ADODB Library to be created by the Server.CreateObject Method.

Methods

Method	Description
BeginTrans	to begin a new transaction
Cancel	to cancel the execution of a pending asynchronous method call.
Close	to close an open object and any dependent objects
CommitTrans	to end the current transaction and save any changes. A new tracnsaction may be started also.
Execute	to execute the specified command text of query, SQL statement, stored procedure or provider-specific text.
Open	to open an connection instance to a data source
OpenSchema	to obtain the database schema information from the provider
RollbackTrans	to end the transaction and cancel any changes made during the current transaction. A new tracnsaction may be started also.

Properties

Property	Description
Attributes	to set or return the value of XactAttributeEnum attribute for a Connection object
CommandTimeout	to set or return the waiting time for executing a command before terminating and generating an error.
ConnectionString	to set or return the details used for creating a connection instance to a data source
ConnectionTimeout	to set or return the waiting time for establishing a connection before terminating and generating an error.
CursorLocation	to set or return the location of the cursor service
DefaultDatabase	to set or return the default database name for a connection object
Errors	to contains all the error objects created in response to a single provider-related failure.
IsolationLevel	to set or return the level of isolation for a connection object
Mode	to set or return the available accessing permissions for modifying data in a connection
Properties	to contains all the property objects for a specific instance of a connection object
Provider	to set or return the provider name of a connection object
State	to return a value to indicate the state of connection is open or closed
Version	to return the ADO version number

Events

Event	Description

Remarks

The methods and properties of Connection object can be grouped into

Connection Information
- Connection Details: ConnectionString; DefaultDatabase; Errors; Properties; State
- Connection Provider Information: OpenSchema; Provider; Version
Connection Manipulation
- Connection Transaction: BeginTrans; CommitTrans; RollbackTrans; Attributes
- Connection Object Manipulation: Cancel; Close; Execute; Open
- Connection Control: CommandTimeout; ConnectionTimeout; CursorLocation; IsolationLevel; Mode

©sideway

ID: 130500016 Last Updated: 9/28/2013 Revision: 1 Ref:

References

Active Server Pages, , http://msdn.microsoft.com/en-us/library/aa286483.aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
ASP Best Practices, , http://technet.microsoft.com/en-us/library/cc939157.aspx
ASP Built-in Objects, , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
Response Object, , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
Request Object, , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
Server Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
Application Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
Session Object (IIS), , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
ASPError Object, , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
ObjectContext Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
Debugging Global.asa Files, , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
How to: Debug Global.asa files, , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
Calling COM Components from ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
IIS ASP Scripting Reference, , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
ASP Keywords, , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
Creating Simple ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
Including Files in ASP Applications, , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
FileSystemObject Object, , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx, , ADO Object Model
ADO Fundamentals, , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx