InterBase Data Access Components 1.00 for Delphi 2006

InterBase Data Access Components (IBDAC) library offers a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. They provide access to InterBase, Firebird and Yaffil database servers. You can use IBDAC as an alternative to standard way of accessing databases using Borland Database Engine (BDE) or dbExpress.

InterBase Server Data Access Components Palette

Using BDE or dbExpress in InterBase-oriented client/server applications has some deficiencies. In many cases BDE and dbExpress users are unable to employ server-specific features. Also BDE leads to excessive usage of resources, reduced speed of processing data, restricted distribution of an application and its administration.

Using BDE in database applications amounts to the following data path between server and client:

[InterBase]<->[Client library]<->[SQL Links]<->[BDE]<->[Application]

IBDAC works directly through native InterBase interface. It allows to avoid using BDE or ODBC:

[InterBase]<->[Client library]<->[Application]

Compared to IBX, IBDAC has same data path but higher performance and additional features.

<!--

Using MySQL network protocol provides optimal transfer way:


[MySQL]<->[Application]


-->
Components

IBDAC includes following components:

  • TIBCConnection - controls server connection;
  • TIBCTransaction - represents server transaction;
  • TIBCQuery - queries execution, operates record set, flexible way updating database tables;
  • TIBCSQL - executes SQL statements;
  • TIBCTable - allows to retrieve and update data single table without writing SQL statement;
  • TIBCStoredProc - executes stored procedures and functions;
  • TIBCSQLMonitor - allows to monitor dynamic SQL executing in IBDAC-based applications;
  • TIBCScript - executes sequence of SQL statements;
  • TIBCConnectDialog - serves for entering username, password and server name;
  • TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search;
  • TVirtualTable - dataset stores data in memory; TIBCAlerter component to transfer messages between connections
Key features

Following are the main features of InterBase Data Access Components:

  • Direct access to server data. No distributing, installing and configuring the BDE and ODBC;
  • VCL, VCL.NET and CLX versions of library;
  • Supports the latest versions of InterBase, Firebird and Yaffil database servers;
  • All data types support;
  • Comprehensive array data type support;
  • High performance controlled fetch of large data blocks;
  • Optimized string data storing;
  • Local data sorting and filtering;
  • Automatic data updating with TIBCQuery and TIBCTable components;
  • Automatic record refreshing and locking;
  • Advanced locking in Firebird 2;
  • Connection pooling feature;
  • InterBase Events support;
  • Unicode and national charsets support;
  • Advanced support for character set OCTETS;
  • Advanced BLOB support;
  • BLOB compression support;
  • TIBCScript component to execute scripts;
  • Advanced generators support;
  • Separated run-time and GUI specific parts allow to create pure console applications such as CGI;
  • Advanced design-time editors;
  • Extended SQL tracing capabilities provided by TIBCSQLMonitor component and DBMonitor application;
  • Borland SQL Monitor support;
  • Automatic design-time components linking;
  • Includes source code of TCRDBGrid enhanced data-aware grid control;
  • Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport;
  • Easy migration from BDE and IBX with Migration Wizard;
  • Macros support in SQL;
  • Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications.
Compatibility

IBDAC supports InterBase 5.x - 7.5, Firebird and Yaffil database servers. Following development environments are supported by IBDAC:

  • Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET and C++ Builder Personality
  • Borland Delphi 2005
  • Borland Delphi 7
  • Borland Delphi 6 with update pack 2
  • Borland Delphi 5
  • Borland C++ Builder 6
  • Borland C++ Builder 5
  • Borland Kylix 3
  • Borland Kylix 2

Only Professional, Enterprise and Architect editions are supported. Also IBDAC does not support Kylix Open Edition.

Related Products

You might be also interested in:

  • VCL components for other databases: Oracle, MySQL, MS SQL


Опубликовал admin
14 Май, Воскресенье 2006г.



Программирование для чайников.