Skip to main content

ZeosDBO: a database middleware components for Borland development tools, including Delphi, C++ Builder and Kylix. Direct access to SQL databases continues to be a vital technology even in today’s enterprise environment.

Currently, there is several standardized and widely used APIs to access SQL databases, such as ODBC, JDBC, and ADO. Borland also released their proprietary database middleware interface for its development tools, called the Borland Database Engine (BDE). Despite being freely distributed with Borland’s popular line of application development tools, the BDE was unpopular because of complexities in installation and poor performance. As Delphi became one of the leading application development tools for the Windows platform, individuals and companies proposed alternative interfaces to the BDE. These “BDE Alternatives” optimized access to the database by directly using the native database driver, providing performance and feature advantages with respect to the BDE.
Realizing the limitations of the BDE, Borland proposed a new type of database interface called dbExpress. This interface was designed to broker access between Delphi and virtually any relational database through 3rd party drivers. Borland significantly improved the performance of dbExpress with respect to the BDE, but the implementation was buggy and supported only a limited subset of SQL that hampered functionality.
The Zeos Database Object component library (ZeosLib) is one of the best-known BDE alternatives. Originally the library was developed for MySQL and PostgreSQL databases, but support for other vendors was soon added. During the development process, certain limitations of the original design became more and more apparent. These limitations began to put a strain on the overall architecture and the development team decided a ground up rewrite was the best way to proceed. The new design was built to handle an extended feature list with several new requirements:
  1. Support for different compilers
  2. Versioning database driver system
  3. Database Insensitive” design for cross-database development
  4. Support for multiple high level interfaces (TDataset, dbExpress, Midas)
  5. Extensible feature system for server specific support
The following compilers are supported:
  • Delphi 5 – 7 and 9-11
  • Lazarus (FreePascal)
  • MSEide+MSEgui (FreePascal)
  • C++ Builder 5 – 6
  • Kylix 2 – 3
ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:
  • MySQL 3.20 – 5.0
  • PostgreSQL 6.5 – 8.1
  • Firebird 1.0 – 2.0
  • Interbase 5.0 – 7.5
  • Microsoft SQL Server 7, 2000
  • Sybase ASE 12.0, 12.5
  • Oracle 9i
  • SQLite 2.8, 3.5
Advantages of using ZeosDBO:
  • Platform independance. 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.
  6. ZComponentDesign – design time components. This package is not available for all compilers. If present it’s only needed to install the components in the IDE.
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.
Author : Zeos Development Group

Popular posts from this blog

Login Form Delphi by Connecting to Ms Access Database.

this the step by step  to making application :

Login Form Delphi by Connecting Ms Access Database.

In making/ building application in Delphi, login Form is an important to protect application so that cannot be open by irresponsible person. This login Form is connected with database so that able to keep a lot of username data and password. Before make the application, please create a database as the picture below:
Picture :Login  form Delphi database Microsoft Access
Save the database in the folder which use to save the application

Next step is create the application

Enter the component and the source code as follows.

No Component NameProperties Value1Label1CaptionUsername2Label2CaptionPassword3Edit1Text -4Edit2Text -5Button1CaptionLogin6Adoconnection1--7AdoQuery1ConnectionADOConnection1

Arrange the component as the picture below:

Figure. Login Form Delphi design form

 Create new form

Form properties can be check in the table below
No Component NameProperties Value1Form1CaptionSuccess…

Step by step Accessing SMS With Delphi: Sending SMS Using Borland Delphi 7 Exploit Comport Component (Siemens))

In this example, will present the way how making SMS delivery program with Delphi, basically, data in data communication series between Delphi and mobile phone happen in Format Protocol Data Unit (PDU). The destination number of sending Message and message that will be sent through Delphi program that is made have to be changed into PDU Form first, next is the data will be sent through serial port to mobile phone. To make the send SMS Application , please enter the following component to Form 1.

No Component NameProperties ValueButton1CaptionConnectButton2CaptionDisConnectButton3CaptionConvert to PDUButton4CaptionSend to HPButton5CaptionClearButton6CaptionStart Send SMSButton7CaptionSet PortEdit1Text-Edit2Text<Type The SMS here>Edit3Text-Label1Caption1) Destination Number :Label2Caption2Label3CaptionPDU lengthLabel4CaptionLabel lengthComLed1--Memo1--Memo2--Comport1--Arrange the Component  in such away so that the visualization program is as follows:

Then type the follow…

The Example Using Chart In Borland Delphi 7

The Example Using Chart In Borland Delphi 7

In this writing will discuss about how to use the chart in Delphi 7. In the example that is made by using Delphi 7, chart will appear 2 data in the form of incremental data number, the first data named data 1 and the second data named data 2. Data 1 is incremental data 1 that is begun from 0 until 10; while data 2 is same. Yet, in the beginning condition of data 1 start from 0 while data 2 start from 1.

To make application as the explanation above, please enter the components in the table below into design form.

NoComponentPropertiesValueNote1Form1CaptionThe Chart of Data on Delphi 72GroupBox1CaptionThe Chart of Data on Delphi 73Label1CaptionData 14Label2CaptionData 25Edit1Text06Edit2Text07Button1CaptionShow to Chart8Button2CaptionClose9Timer1EnabledFalse10Chart--Check the NoteNote:

Double click on chart component, set the property of chart as below:

Click on  Add.. Button

Then the following chart gallery will be shown:

Choose the…