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. |