Constructor

constructor

Create Object of type AdoConnection

Properties

Attributes

One or more characteristics of a connection

CommandTimeout

How long to wait while executing a command

ConnectionString

The information used to establish a connection to a data source

ConnectionTimeout

How long to wait while establishing a connection before terminating the attempt and generating an error.

CursorLocation

The location of the cursor service

DefaultDatabase

The default database for a Connection object.

Errors

Collection of errors occurred at the latest ADO operation

IsolationLevel

The level of isolation for a Connection object.

Mode

The available permissions for modifying data in the Connection object

Provider

The name of the provider for the Connection

State

Is the object open or closed.

Version

The ADO version number.

Method

BeginTrans()

Begins a new transaction

Cancel()

Cancels execution of a pending, asynchronous Execute or Open method call.

Close()

Closes an open connection and any dependent objects

CommitTrans()

Saves any changes and ends the current transaction

DisableEvents()

Disable Event handling

EnableEvents()

Enable Event handling

Execute()

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

Open()

Opens a connection to a data source.

OpenSchema()

Obtains database schema information from the provider

RollbackTrans()

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