ADO Connection Object
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
ADO Connection Object
❮ Previous
Next ❯
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 |
<!--
mid_content, all: [300,250][336,280][728,90][970,250][970,90][320,50][468,60]-->
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 |
❮ Previous
Next ❯
