ODBC DRIVER INSTALLATION

To configure database connectivity in Ozeki Message Server, you need to set up an ADO and ODBC driver. This page gives you detailed information if you wish to install and configure the MySQL ODBC driver called MyODBC. The installation of other database drivers are similar to this installation.

MyODBC installation and configuration

Step 1 - Download the MyODBC database driver

You can use the following link:

https://dev.mysql.com/downloads/connector/odbc/

Step 2 - Install the downloaded MyODBC database driver

Start the downloaded exe file. The installation is similar to the installation of any windows application. Click on the Next and Ok buttons.

Step 3 - Set up a datasource

If the driver is available on your system, you need to set up a datasource. To launch the ODBC Data Source Administrator software, please open the Start Menu and start typing ODBC. You OS will start to search for the program. If you have found it,click the ODBC Data Sources (64 bit) icon to launch it.

datasource administrator
Figure 1 - Datasource administrator

This will open the data source administrator, which is part of Windows (Figure 1). In the datasource administrator, you must define a datasource. Click on User DSN Tab (it is the default tab) and click Add as shown in the figure above. The will bring up the Create New Datasource form (Figure 2).

create a new datasource
Figure 2 - Create new datasource

On this form you need to select the newly installed driver and click on Finish. In most cases when you click on Finish a database server specific configuration form comes up. On this form specify the database that can be used by Ozeki Message Server.

database driver configuration
Figure 3 - Database driver configuration

In case of MyODBC, enter the details as can be seen in Figure 3. (In the database name enter your database name) and after filling in all the proper fields click on the Test to check if you have properly configured your Database settings.

If the test connection succeeds, it means you have a working datasource, that can be attached to Ozeki Message Server.

More information