<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>ZeosDBO Technical Info</title><link rel="stylesheet" href="ede.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.66.0"></head><body><div xmlns="" id="customheader"><a href="http://zeos.firmos.at/portal.php" style="color: #fff; font-weight: bold;">ZeosLib</a><b> - open source tools for your database solutions</b></div><div class="article" lang="en"><div class="titlepage"><div><div><h1 class="title"><a id="d4e1"></a>ZeosDBO Technical Info</h1></div><div><h3 class="corpauthor">ZeosLib Development Group</h3></div><div><p class="pubdate">09 July 2004 (Updated 29/5/2008)</p></div></div><hr></div><p>ZeosDBO is a database middleware components for Borland development tools, including Delphi, C++ Builder and Kylix.</p><p>The following compilers are supported:</p><div class="itemizedlist"><ul type="disc" compact><li>Delphi 5 - 7 and 9-11</li><li>Lazarus (FreePascal)</li><li>MSEide+MSEgui (FreePascal)</li><li>C++ Builder 5 - 6</li><li>Kylix 2 - 3</li></ul></div><p>ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:</p><div class="itemizedlist"><ul type="disc" compact><li>MySQL 3.20 - 5.0</li><li>PostgreSQL 6.5 - 8.1</li><li>Firebird 1.0 - 2.0</li><li>Interbase 5.0 - 7.5</li><li>Microsoft SQL Server 7, 2000</li><li>Sybase ASE 12.0, 12.5</li><li>Oracle 9i</li><li>SQLite 2.8, 3.5</li></ul></div><p>For other databases we propose to use implemented Active Data Objects (ADO) Bridge.</p><p>Advantages of using ZeosDBO:</p><div class="itemizedlist"><ul type="disc" compact><li>Platform independance. The ZeosDBO is highly generic. Applications written in ZeosDBO can be migrated across databases without major changes.</li><li>ZeosDBO is open source, written for usability and extensibility.</li><li>ZeosDBO leverages the amazing power of the Delphi development environment without relying on a performance killing middleware.</li><li>ZeosDBO is an extremely thin abstraction layer, unlike 'thick' layered protocols like ADO and BDE.</li></ul></div><p>Package contents:</p><div class="orderedlist"><ol type="1" compact><li><tt class="classname">ZCore</tt> - Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions.</li><li><tt class="classname">ZParseSql</tt> - SQL specific for syntax and lexical analysis.</li><li><tt class="classname">ZPlain</tt> - Native plain API to supported SQL servers.</li><li><tt class="classname">ZDbc</tt> - Port of Java Database Connectivity API (JDBC 2.0). DBC API acts as intermediate layer between Plain API and highlevel <tt class="classname">TDataset</tt> or <tt class="classname">DBExpress</tt> components</li><li><tt class="classname">ZComponent</tt> - visual components descended from <tt class="classname">TDataset</tt>.</li><li><tt class="classname">ZComponentDesign</tt> - design time components. This package is not available for all compilers. If present it's only needed to install the components in the IDE.</li></ol></div><p>Installed components:</p><div class="orderedlist"><ol type="1" compact><li><tt class="classname">TZConnection</tt>: This component encapsulates the database connection and transaction management.</li><li><tt class="classname">TZReadOnlyQuery</tt>: TDataset component to execute SQL queries and process data in read-only mode.</li><li><tt class="classname">TZQuery</tt>: TDataset component which allows data modifications in regular and cached mode.</li><li><tt class="classname">TZUpdateSQL</tt>: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications.</li><li><tt class="classname">TZStoredProc</tt>: The component to execute SQL stored procedures.</li><li><tt class="classname">TZSQLProcessor</tt>: The component to execute SQL scripts for different SQL and various delimiter types.</li><li><tt class="classname">TZSQLMonitor</tt>: The component to monitor all outgoing SQL queries and other logging information.</li><li><tt class="classname">TZSQLMetadata</tt>: Specialized TDataset component which provides an access to database metadata such as tables, columns, indices, etc.</li></ol></div><p>The project home page is here (for news, links and other project info): <a href="http://zeosfirmos.at/portal.php" target="_top">http://zeos.firmos.at</a></p><p>The sourceforge development site is located here (for technical resources and anonymous web based cvs access):<a href="http://www.sourceforge.net/projects/zeoslib" target="_top"> http://www.sourceforge.net/projects/zeoslib</a></p><p>Thank you for using our software,</p><p>The ZeosLib Development Group</p></div><div xmlns="" id="customfooter">
(c) 1999 - 2006 The Zeos Development Group
</div></body></html>
