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.