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 |
No comments:
Post a Comment