Delphi Onderdils The Delphi Resources

Generally we always create MySQl database using tool like heidisql, mysql yog, phpadmind and so on. But in this tutorial I will show how to create database and table using delphi by runtime. Many ways to create  MySQL  database with runtime for example :

• Import sql text by shellexecute to call mysql.exe or call batch file
• Using Tzconnection
• Using ZSQLProcessor
• Using TZQuery
• or may be using ado component witch connected with ODBC

In this section I will give example how to create MySQL database using Tzconnection

Next… on

Continue Reading…

ZEOS is one component package to connect delphi with mysql database. to be able to interact with MySQL database ZEOS requires a library file that is libmysql.dll, the file can be obtained at the time we install heidisql. File position is located in C: \ Program Files \ HeidiSQL \libmysql.dll
we can download heidisql www.heidisql.com site.
ok.. next..

Continue Reading…

HeidiSQL is one of tool to manage MySQL database . Heidisql is build from delphi and zeos component, it is for free. we can download at  http://www.heidisql.com

HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

Features

Continue Reading…

ZeosDBO Installation Guide

• You can download the current (SVN) version from svn://www.firmos.at/zeos/trunk/
• The development/testing branch is at svn://www.firmos.at/zeos/branches/testing/
• Snapshots can be found at http://zeosdownloads.firmos.at/downloads/snapshots/

Official reaseses are published at the Zeoslib forum [http://zeos.firmos.at/portal.php] and the Zeoslib Source-
forge Project pages [http://sourceforge.net/projects/zeoslib]

1.    Unpack the archive to a folder (not for SVN versions, of course)

2.    Copy the required dlls for your database client to the windows system directory (usually    Win-
dows\System or winnt\system32) or use the database client installer.
Attention : think about licence issues when working with the database client libraries. Not all software is
freely distributable in all situations. These libraries are NOT a part of the zeoslib packages.

3.    Add the build Directory of the package you are about to install to Delphi’s library path.

4.    Locate the package directory associated with your compiler and open the ZeosDbo.bpg project group.
Load the project and compile the following components in the order listed (or just choose compile all
from Project-Menu):

• ZCore.bpl
• ZParseSql.bpl
• ZPlain.bpl
• ZDbc.bpl
• ZComponent.bpl

Continue Reading…

GNU LESSER GENERAL PUBLIC
LICENSE

Copyright (C) 1991, 1999 Free Software Foundation, Inc. 59 Temple Place, Suite 330, Boston, MA 02111-1307
USA Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is
not allowed.

[This is the first released version of the Lesser GPL. It also counts as the successor of the GNU Library Public
License, version 2, hence the version number 2.1.]

1. Preamble

The licenses for most software are designed to take away your freedom to share and change it. By contrast, the
GNU General Public Licenses are intended to guarantee your freedom to share and change free software–to
make sure the software is free for all its users.
Continue Reading…

ZeosDBO Technical Info

ZeosLib Development Group

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

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

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