HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
The ADO Connection Object is used to create an open connection to a data source. Through thisconnection, you can access and manipulatea database
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.
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 |
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 |
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 |
Collection | Description |
---|---|
Errors | Contains all the Error objects of the Connection object |
Properties | Contains all the Property objects of the Connection object |