Previous Topic

Next Topic

Book Contents

Book Index

Connecting to MySQL

Prerequisite Software

In order to connect to a MySQL server you will need the MySQL Client and ODBC Driver installed on your machine. These components are packaged together as the MySQL Connector (they had previously been called MyODBC). MySQL Connector can be downloaded from the MySQL site www.mysql.org/

There are a number of third-party ODBC Drivers, such as Devart (https://www.devart.com/odbc/mysql/). We haven't used this ODBC Driver so cannot comment on its capabilities.

Configuring the Connection to your MySQL Server

Once MySQL Connector has been installed, you need to configure an ODBC Datasource for your database. The general process for doing this is described in Configuring a Database Connection.

To configure this, specify:

It is recommended that you click on Test Data Source to test that your connection has been configured correctly.