ADO 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.
|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|
|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|
Note: You cannot handle events using VBScript or JScript (only Visual Basic, Visual C++, and Visual J++ languages can handle events).
|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|
|Errors||Contains all the Error objects of the Connection object|
|Properties||Contains all the Property objects of the Connection object|
Thank You For Helping Us!
Your message has been sent to W3Schools.