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.
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).
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.
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
- ODBC configuration
- Service account
- Microsoft-SQL
- Backward compatibility
- MyODBC driver