Home arrow Delphi-Kylix arrow Page 2 - Using Delphi with MySQL
DELPHI-KYLIX

Using Delphi with MySQL


Businesses that are strapped for money but need an RDBMS know that MySQL fits the bill. It works well with many programming languages, but what do you do if you need to write a multi-user database application for it in a language that it doesn't support quite as well? That's the challenge our author faced as a Delphi programmer. To see how he tackled it, keep reading.

Author Info:
By: Leidago
Rating: 5 stars5 stars5 stars5 stars5 stars / 22
October 25, 2006
TABLE OF CONTENTS:
  1. · Using Delphi with MySQL
  2. · Required Tools
  3. · Setting up the Connector
  4. · The Application
  5. · Form Two

print this article
SEARCH DEVARTICLES

TOOLS YOU CAN USE

advertisement
Using Delphi with MySQL - Required Tools
(Page 2 of 5 )

Here is the list of tools you will need:

  • MySQL Database Server
  •  MySQL Connector/ODBC  3.51
  •  MyCC(optional)

You can download ODBC Connector from http://dev.mysql.com/get/Downloads/MyODBC3/mysql-connector-odbc-3.51.12-
win32.zip/from/pick
. Pick a mirror from which to download the package. Unzip and run the executable.

Then download the MySQL Server from the downloads page of the MySQL site located at http://www.mysql.org/.

Next download the MySQL Control Center (MyCC) application from http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html

MyCC is basically a database management program that enables you to create, delete, view and update databases that is served by MySQL. Please note that you do not have to download this program; in fact, you do not have to download any MySQL database admin applications at all. You could simply use the command line interface of the server to create and administer your databases. But you will need to know a bit of SQL in order to use the command line interface. I suggest that you download a MYSQL database management program if you do not want to learn SQL.

To summarize, there are three things we need to do to use MySQL Server with our Delphi application:

  1. Download and install MySQL Server from http://www.mysql.org.
  2. Download  and install MySQL ODBC Connector.
  3. Download and install MyCC (optional but recommended).

Once you have all of them installed, we then need to create the database. Our application is going to have a database called publish and a table called articles. It will handle the submission, editing and deleting of articles.


blog comments powered by Disqus
DELPHI-KYLIX ARTICLES

- Loading an XML Document into the DOM
- Delphi Wrapper Classes and XML
- Delphi and the DOM
- Delphi and XML
- Internet Access: Client Service
- Finishing the Client for an Internet Access ...
- The Client for an Internet Access Control Ap...
- User Management for an Internet Access Contr...
- Important Procedures for an Internet Access ...
- Server Code for an Internet Access Control A...
- Constructing the Interface for an Internet A...
- Building a Server Application for an Interne...
- Building an Internet Access Control Applicat...
- Client Dataset: Working with Data Packets an...
- Using the Client Dataset in an N-Tiered Appl...

Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 



© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 9 - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials