C.1.2- The Connection Object

Name

Returns

Description

BeginTrans

Integer

Begins a new transaction.

Cancel

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

Close

Closes an open connection and any dependent objects.

CommitTrans

Saves any changes and ends the current transaction.

Execute

Recordset

Executes the query, SQL statement, stored procedure, or provider specific text.

Open

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

OpenSchema

Recordset

Obtains database schema information from the provider.

RollbackTrans

Cancels any changes made during the current transaction and ends the transaction.

Name

Returns

Description

Attributes

Long

Indicates one or more characteristics of a Connection object. Default is 0.

CommandTimeout

Long

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

ConnectionString

String

Contains the information used to establish a connection to a data source.

ConnectionTimeout

Long

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

CursorLocation

CursorLocation
Enum

Sets or returns the location of the cursor engine.

Name

Returns

Description

DefaultDatabase

String

Indicates the default database for a Connection object.

Errors

Errors

Contains all of the Error objects created in response to a single failure involving the provider.

IsolationLevel

IsolationLevel
Enum

Indicates the level of transaction isolation for a Connection object. Write-only.

Mode

ConnectMode
Enum

Indicates the available permissions for modifying data in a Connection.

Properties

Properties

Contains all of the Property objects for a Connection object.

Provider

String

Indicates the name of the provider for a Connection object.

State

Long

Describes whether the Connection object is open or closed. Read-only.

Version

String

Indicates the ADO version number. Read-only.

Name

Description

BeginTransComplete

Fired after a BeginTrans operation finishes executing.

CommitTransComplete

Fired after a CommitTrans operation finishes executing.

ConnectComplete

Fired after a connection starts.

Disconnect

Fired after a connection ends.

ExecuteComplete

Fired after a command has finished executing.

InfoMessage

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

RollbackTransComplete

Fired after a RollbackTrans operation has finished executing.

WillConnect

Fired before a connection starts.

WillExecute

Fired before a pending command executes on the connection.