Connection Object
A Connection object represents an open connection to an OLE DB data
source.
Collections
Errors, Properties
Properties
Attributes, CommandTimeout,
ConnectionString, ConnectionTimeout,
DefaultDatabase, IsolationLevel,
Mode, Provider, Version
Methods
BeginTrans, CommitTrans,
RollbackTrans, Close,
Execute, Open
Remarks
You can create Connection objects independently of any other previously
defined object.
A Connection object represents a unique session with a data source. In
the case of a client/server database system, it may be equivalent to an actual
network connection to the server. Depending on the functionality the provider
exposes, some collections, methods, or properties of a Connection
object may not be available.
Note For information on Microsoft OLE DB providers including the
Microsoft ODBC Provider for OLE DB, see the documentation for the
Microsoft® OLE DB SDK or visit the Microsoft OLE DB web page.
Using the collections, methods, and properties of a Connection object,
you can do the following:
· Configure the connection before opening
it with the ConnectionString, ConnectionTimeout,
and Mode properties.
· Set the default database for the
connection with the DefaultDatabase
property.
· Set the level of isolation for the
transactions opened on the connection with the IsolationLevel
property.
· Select an OLE DB provider with the Provider
property.
· Establish, and later break, the physical
connection to the data source with the Open and Close
methods.
· Execute a command on the connection with
the Execute method and configure the execution
with the CommandTimeout property.
· Manage transactions on the open
connection, including nested transactions if the provider supports them, with
the BeginTrans, CommitTrans,
and RollbackTrans methods and the Attributes
property.
· Examine errors returned from the data
source with the Errors collection.
· Read the version from the ADO
implementation in use with the Version property.
See Also
Command, Recordset
| 
