РУС 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

Features | Detailed Description

The DB Connection is a component from the Database Comparer VCL library.
This component implements live database connection. Use DB Connection together with DB ComparerDB Extractor and SQL Executor components for comparing and synchronizing the database structure.

Features:

  • MSSQL, Oracle, MySQL, InterBase, Sybase, Postgre SQL databases
  • ADO, BDE, IBX, FIB, IBO, ZEOS, AnyDAC database libraries
  • Full SQL Server 2005 support
  • Wide range of connection options: Server Version, SQL dialect, Character set, Role

Connect to most popular databases

The Database Connection component implements generic live database connection. By using this component you can connect to different databases via any supported database library. Use Database Connection if you want to work with different database types.

DBConnection1.ConnectionType := cnIBX;
with DBConnection1.ConnectionOptions do begin
   DatabaseName := 'database';
   HostName := 'server';
   UserName := 'user';
   Password := 'password';
end;
DBConnection1.Connected := True;

IBSQLExec1.DBCConnection := DBConnection1;
IBSQLExec1.ExecuteScript;

You can always use database specific connection component e.g.: DB ConnectionADO, DB ConnectionIBX, DB ConnectionBDE etc. This feature allows you to bind standard VCL connection object to Database Comparer components.

DBConnectionADO1.Connection := ADOConnection1;
DBConnectionADO1.Connection.ConnectionString := ConnectionString;
DBConnectionADO1.Connected := True;

MSSQLExec1.DBCConnection := DBConnectionADO1;
MSSQLExec1.ExecuteScript;

Samples in Delphi and C++Builder

Please see the Demos code and also the indexed Help documentation provided with the Database Comparer VCL installation to learn more about using this component in your application.

Complete Delphi source code

When Purchasing the Database Comparer VCL you receive the full sources for all components and also free unlimited support.

Interested?

    Copyright © 2000-2017