ADO Connection Object

The Connection Object |
A Connection object represents an open connection to a data store.

BeginTrans |
Returns: Integer | Method
Begins a new transaction.

Cancel |
| Method
Cancels the execution of a pending, asynchronous Execute or Open operation.

Close |
| Method
Closes an open connection and any dependant objects.

CommitTrans |
| Method
Saves any changes and ends the current transaction.

Execute |
Returns: Recordset | Method
Executes the query, SQL statement, stored procedure, or provider specific text.

Open |
| Method
Opens a connection to a data source, so that commands can be executed against it.

OpenSchema |
Returns: Recordset | Method
Obtains database schema information from the provider.

RollbackTrans |
| Method
Cancels any changes made during the current transaction and ends the transaction.

Attributes |
Returns: Long | Property
Indicates one or more characteristics of a Connection object. Default is 0.

CommandTimeout |
Returns: Long | Property
Indicates how long, in seconds, to wait while executing a command before terminating the command and generating an error. The default is 30.

ConnectionString |
Returns: String | Property
Contains the information used to establish a connection to a data source.

ConnectionTimeout |
Returns: Long | Property
Indicates how long, in seconds, to wait while establishing a connection before terminating the attempt and generating an error. Default is 15.

CursorLocation |
Returns: CursorLocation Enum | Property
Sets or returns the location of the cursor engine.

DefaultDatabase |
Returns: String | Property
Indicates the default database for a Connection object.

Errors |
Returns: Errors | Property
Contains all of the Error objects created in response to a single failure involving the provider.

IsolationLevel |
Returns: IsolationLevel Enum | Property
Indicates the level of transaction isolation for a Connection object. Write only.

Mode |
Returns: ConnectMode Enum | Property
Indicates the available permissions for modifying data in a Connection.

Properties |
Returns: Properties | Property
Contains all of the Property objects for a Connection object.

Provider |
Returns: String | Property
Indicates the name of the provider for a Connection object.

State |
Returns: Long | Property
Describes whether the Connection object is open or closed. Read only.

Version |
Returns: String | Property
Indicates the ADO version number. Read only.

BeginTransComplete |
| Event
Fired after a BeginTrans operation finishes executing.

CommitTransComplete |
| Event
Fired after a CommitTrans operation finishes executing.

ConnectComplete |
| Event
Fired after a connection starts.

Disconnect |
| Event
Fired after a connection ends.

ExecuteComplete |
| Event
Fired after a command has finished executing.

InfoMessage |
| Event
Fired whenever a ConnectionEvent operation completes successfully and additional information is returned by the provider.

RollbackTransComplete |
| Event
Fired after a RollbackTrans operation finished executing.

WillConnect |
| Event
Fired before a connection starts.

WillExecute |
| Event
Fired before a pending command executes on the connection.