|
DBConnection class (with underlying DBConnectionXXX classes customized for different database engines) implements generic live database connection. Simply set the ConnectionType property to desired database engine. Please use DBConnection if you want to work with different database types. Otherwise, you can always use database specific connection class e.g.: DBConnectionADO / DBConnectionIBX / DBConnectionBDE etc.
DBConnectionXXX connection components are used by all Database Comparer VCL which requires access to database. The TxxxSQLExec (executes script) and TxxxDBExtract (extracts metadata from database) components are probably most notable among them.
Currently supported the following database engines: ADO, BDE, DBX, IBX, FIB, IBO, ZEOS, MyDAC, ODAC, AnyDAC and PGDAC. This list is constantly updated and support for other database engines will be added in the future versions of the Database Comparer VCL.
Please see the Demos code and also the indexed Help documentation provided with the Database Comparer VCL installation for more details about using this component.
 Name |
 Description |
 ConnectionOptions |
Holds information required to establish connection to database such as database name, path, user name etc. |
| ConnectionType |
Gets or sets the type of database connection - IBExpress, FIBPlus, ADO. |
| DatabaseType |
Gets or sets the type of underlying database - Interbase, MS SQL, Oracle etc. |
| IBServerOptions |
Interbase server options. |
| SupportedConnections |
List of supported database engines. |
| SupportedDatabases |
List of supported database types. |
| Connected |
Returns True if database connection is established. |
|
| Name |
Description |
| Commit |
Commits current transaction. |
| CreateDatabase |
Creates a new database using the ConnectionOptions options. |
| InTransaction |
Returns True if underlying database is in transaction. |
| ReConnect |
Reconnects to the underlying database. |
| Rollback |
Rollbacks the current transaction. |
| StartTransaction |
Starts a new transaction. |
|
| Name |
Description |
| OnAfterConnect |
Occurs when the database connection established successfully. |
| OnAfterDisconnect |
Occurs after disconnecting from database. |
| OnBeforeConnect |
Occurs before connecting to database. |
| OnBeforeDisconnect |
Occurs after disconnecting from database. |
| OnErrorMessage |
Occurs when error message captured. |
|
|
