Site Map Contact Us Home
E-mail Newsletter
Subscribe to get informed about
Clever Components news.

Your Name:
Your Email:
 
SUBSCRIBE
 
Previous Newsletters
 






Products Articles Downloads Order Support
Customer Portal     

DB Connection Description

Features | Detailed Description

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.

Property List

  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.

Method List

  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.

Event List

  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.

    Copyright © 2000-2019