dBASE and mySQL Tutorials

Join me as I perform a step-by-step installation of the mySQL 5.1 Database Server and the mySQL ODBC Driver 3.51 on my Windows XP Professional machine. Then watch as I connect to it using the Borland Database Engine and talk to the server right from dBASE Plus. Note: The mySQL company has a habit of moving stuff around on their website, so it may or may not appear as it does in the tutorial. This tutorial is version 4 and is current as of 20 April 2009.

There are 4 parts to getting the system running:

• the mySQL 5.1 Database Server - in the tutorial, I install the database server right here on a Windows XP Professional PC. However, this may not be appropriate for you, for example if you are trying to connect to a mySQL database that exists on a LAN database server, or if you are accessing a mySQL database thousands of miles away over the internet. Whatever your configuration is, you need to have a mySQL database somewhere to connect to! If you are trying to connect to an existing database, you can skip Step 1 - but remember that when the following steps refer to the database server on localhost, you will need to substitute the location of your server.
• the mySQL ODBC Driver 3.51 - this is required to connect a Windows system to the mySQL database
• the BDE Alias configuration - the Borland Database Engine allows dBASE to connect via ODBC
• the dBASE configuration

There are 4 parts to this tutorial:

• Step 1: Installing the mySQL 5.1 Database Server
• Step 2: Installing the mySQL ODBC Driver 3.51
• Step 3: Connecting dBASE to mySQL using the BDE
• Step 4: Getting to the mySQL data in dBASE

The MySQL Logo is a registered trademark of MySQL AB in the United States, the European Union and other countries.

Problems? Comments? Please contact us.
© ChelseaData.ca Home About