ALOMOHORA

ZeosDBO is a database middleware component for Borland development tools, including Delphi, C++ Builder and Kylix.

The following compilers are supported:

• Delphi 4 – 7.
• C++ Builder 4 – 6.
• Kylix 1 – 3.

ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:

• MySQL 3.20 – 4.1
• PostgreSQL 6.5 – 7.3
• Firebird 1.0 – 1.5
• Interbase 5.0 – 7.5
• Microsoft SQL Server 7, 2000
• Sybase ASE 12.0, 12.5

For other databases we propose to use implemented Active Data Objects (ADO) Bridge.

Advantages of using ZeosDBO:

• Platform independence. The ZeosDBO is highly generic. Applications written in ZeosDBO can be migrated across databases without major changes.

• ZeosDBO is open source, written for usability and extensibility.

• ZeosDBO leverages the amazing power of the Delphi development environment without relying on a performance killing middleware.

• ZeosDBO is an extremely thin abstraction layer, unlike ‘thick’ layered protocols like ADO and BDE.

Package contents:

1. ZCore – Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions.

2. ZParseSql – SQL specific for syntax and lexical analysis.

3. ZPlain – Native plain API to supported SQL servers.

4. ZDbc – Port of Java Database Connectivity API (JDBC 2.0). DBC API acts as intermediate layer between Plain API and highlevel TDataset or DBExpress components.

5. ZComponent – visual components descended from TDataset.

Installed components:

1. TZConnection: This component encapsulates the database connection and transaction management.

2. TZReadOnlyQuery: TDataset component to execute SQL queries and process data in read-only mode.

3. TZQuery: TDataset component which allows data modifications in regular and cached mode.

4. TZUpdateSQL: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications.

5. TZStoredProc: The component to execute SQL stored procedures.

6. TZSQLProcessor: The component to execute SQL scripts for different SQL and various delimiter types.

7. TZSQLMonitor: The component to monitor all outgoing SQL queries and other logging information.

8. TZSQLMetadata: Specialized TDataset component which provides an access to database metadata such as tables, columns, indices, etc.

The project home page is here (for news, links and other project info): http://www.zeoslib.net

Incoming search terms for the article:

ZEOSDBO, TZSQLMetadata, tzsqlmonitor, tzstoredproc, ZEOS DBO, zeosdbo-7, zeosdbo mssql authentication, ZEOSDBO Delphi xe, zeosdbo 7, zeos zquery, zeoslib delphi xe, ms sql zeosdb, ZeosDB Sybase, zeos tzsqlmetadata, zeos TZStoredProc, zeosdbo executedirect, TZSQLMetadata delphi, using tzsqlmonitor, tzsqlprocessor example, delphi tzsqlmetadata, ZeosDB 7, using tzstoredproc in delphi 7, zeosdb mssql, zeos deletesql, update sql dari delphi dan zeosdbo, update com zQUERYdelphi, tzupdateSQL For UPDATE, what delphi xe unit is wm_icontray declared in, zeos zquery insert update delete, zeodbo, zeos tzstoredproc example, zeos connector delphi 7, zeos dbo delphi xe, zeos sql server, zeos insert sql server, zeos dbo mssql procedure, zeosdbo c builder xe, zeosdbo c builder4, zeosdbo using tzsqlmetadata, zeosdbo visual studio, zeosdbo-7 delphi6, zeosdbo7 delphi 5, zeoslib create database tzsqlprocessor, zeoslib delphi, zeoslibdbo: how to use tzupdatesql, zeoslib jdbc, zeoslib kylix installing, zeoslib package delphi, zeoslib sql, zeoslib sql insert, zeoslib transction handling, zeosdbo updatesql, zeosdbo TzUpdateSQl, ZEOSDBO com, zeosdbo component, zeosdbo component for delphi 6, ZeosDBO components, zeosdbo execute, zeosdbo FOR DELPHI 4, zeosdbo for delphi XE, zeosdbo mssql, zeosdbo mssql stored procedure, zeosdbo package, zeosdbo sql server, zeosdbo supports, zeosdbo tdataset, zeoslib tzsqlmetadata, ??? ?????????? zeoslib ?? delphi xe, delphi xe zeos tzstoredproc, delphi zeos executar scritp sql, delphi zeos sql insert, delphi zeosdb 7, delphi zeosdb postgre sql, delphi4 zeos postgre connector, encapsulated tzquery, example zeos TZUpdateSQL, EXECUTAR SQL PROCEDURE ZEOS, firebird transaction tzstoredproc, how to install zeoslib for delphi xe, how to use TZSQLMetaData, how to using TZUpdateSQL with delphi, delphi xe mysqlconnection, delphi xe form on taskbar, build delphi xe app using mysql, builder C zeosdbo installation guide, como usar tzstoredproc, como usar tzupdatesql, como usar zeosdbo tzsqlmetadata, delete query delphi zeos, delphi 6 zeoslib install, delphi add zeosdbo, delphi how to install zeosdbo, delphi how to use zeosdbo, delphi sql middleware components, delphi stored procedure zeos, delphi tzsqlprocessor delimiter firebird, icon disable state delphi, install zeosdbo delphi6, tzquery zeos delphi insert record, tzreadonlyquery delphi