Connection Object The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access a...
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 |
Collections
| Collection | Description |
| Errors | Contains all the Error objects of the Connection object |
| Properties | Contains all the Property objects of the Connection object |
