Connection Object
The ADO Connection Object is used to create an open
connection to a data source. Through this connection, you can
access and manipulate a database.
If you want to access a database multiple times, you should
establish a connection using the Connection object. You can also
make a connection to a database by passing a connection string
via a Command or Recordset object. However, this type of
connection is only good for one specific, single query.
ProgID
set objConnection=Server.CreateObject("ADODB.connection")
|
Properties
| Property |
Description |
| Attributes |
Sets or returns the attributes of a
Connection object |
| CommandTimeout |
Sets or returns the number of seconds
to wait while attempting to execute a command |
| ConnectionString |
Sets or returns the details used to
create a connection to a data source |
| ConnectionTimeout |
Sets or returns the number of seconds
to wait for a connection to open |
| CursorLocation |
Sets or returns the location of the
cursor service |
| DefaultDatabase |
Sets or returns the default database
name |
| IsolationLevel |
Sets or returns the isolation level |
| Mode |
Sets or returns the provider access
permission |
| Provider |
Sets or returns the provider name |
| State |
Returns a value describing if the
connection is open or closed |
| Version |
Returns the ADO version number |
Methods
| Method |
Description |
| BeginTrans |
Begins a new transaction |
| Cancel |
Cancels an execution |
| Close |
Closes a connection |
| CommitTrans |
Saves any changes and ends the current
transaction |
| Execute |
Executes a query, statement, procedure
or provider specific text |
| Open |
Opens a connection |
| OpenSchema |
Returns schema information from the
provider about the data source |
| RollbackTrans |
Cancels any changes in the current
transaction and ends the transaction |
Events
Note: You cannot handle events using VBScript or
JScript (only Visual Basic, Visual C++, and Visual J++ languages
can handle events).
| Event |
Description |
| BeginTransComplete |
Triggered after the BeginTrans
operation |
| CommitTransComplete |
Triggered after the CommitTrans
operation |
| ConnectComplete |
Triggered after a connection starts |
| Disconnect |
Triggered after a connection ends |
| ExecuteComplete |
Triggered after a command has finished
executing |
| InfoMessage |
Triggered if a warning occurs during a
ConnectionEvent operation |
| RollbackTransComplete |
Triggered after the RollbackTrans
operation |
| WillConnect |
Triggered before a connection starts |
| WillExecute |
Triggered before a command is executed |
Collections
| Collection |
Description |
| Errors |
Contains all the Error objects of the
Connection object |
| Properties |
Contains all the Property objects of
the Connection object |
|
