ADO Connection Object

From http://www.w3schools.com (Copyright Refsnes Data)

# ADO Connection Object

## Connection Object

The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.

If you want to access a database multiple times, you should establish a connection using the Connection object. You can also make a connection to a database by passing a connection string via a Command or Recordset object. However, this type of connection is only good for one specific, single query.

### ProgID

    set objConnection=Server.CreateObject("ADODB.connection")

### Properties

Property | Description
--- | ---
Attributes | Sets or returns the attributes of a Connection object
CommandTimeout | Sets or returns the number of seconds to wait while attempting to execute a command
ConnectionString | Sets or returns the details used to create a connection to a data source
ConnectionTimeout | Sets or returns the number of seconds to wait for a connection to open
CursorLocation | Sets or returns the location of the cursor service
DefaultDatabase | Sets or returns the default database name
IsolationLevel | Sets or returns the isolation level
Mode | Sets or returns the provider access permission
Provider | Sets or returns the provider name
State | Returns a value describing if the connection is open or closed
Version | Returns the ADO version number

### Methods

Method | Description
--- | ---
BeginTrans | Begins a new transaction
Cancel | Cancels an execution
Close | Closes a connection
CommitTrans | Saves any changes and ends the current transaction
Execute | Executes a query, statement, procedure or provider specific text
Open | Opens a connection
OpenSchema | Returns schema information from the provider about the data source
RollbackTrans | Cancels any changes in the current transaction and ends the transaction

### Events

Note: You cannot handle events using VBScript or JScript (only Visual Basic, Visual C++, and Visual J++ languages can handle events).

Event | Description
--- | ---
BeginTransComplete | Triggered after the BeginTrans operation
CommitTransComplete | Triggered after the CommitTrans operation
ConnectComplete | Triggered after a connection starts
Disconnect | Triggered after a connection ends
ExecuteComplete | Triggered after a command has finished executing
InfoMessage | Triggered if a warning occurs during a ConnectionEvent operation
RollbackTransComplete | Triggered after the RollbackTrans operation
WillConnect | Triggered before a connection starts
WillExecute | Triggered before a command is executed

### Collections

Collection | Description
--- | ---
Errors | Contains all the Error objects of the Connection object
Properties | Contains all the Property objects of the Connection object

From http://www.w3schools.com (Copyright Refsnes Data)