Connection Object

Methods

Name	Returns	Description
BeginTrans	Integer	Begins a new transaction. This statement must be followed by CommitTrans or the transaction will be rolled-back.
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. This statement must be preceded by BeginTrans .
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.

Properties

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	CursorLocationEnum	Sets or returns the location of the cursor engine - client or server.
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	IsolationLevelEnum	Indicates the level of transaction isolation for a Connection object. Write only.
Mode	ConnectModeEnum	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.

Events

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 finishes executing.
WillConnect	Fired before a connection starts.
WillExecute	Fired before a pending command executes on the connection.