Page History

...

Download the mysql-connector from the link https://dev.mysql.com/downloads/connector/odbc/ as per your server configurations.
Install mysql-connector on the server where Sage is hosted.
On the server navigate to Control panel -> Administrative Tools.
Double click on the service Data Source (ODBC).
From the User DSN tab -> Click Add button which will pop up “Create New Data Source” option
Scroll down to select option “MySql ODBC 5.3 unicode driver” and hit Finish button
This will pop up the Connection parameters which are explained after these steps.
Click on Test button to test the connection of your entered parameters.

Parameter	Description
Data Source Name	Enter the name of your choice by which you want to identify the connection.
TCP/IP server	Enter the ip/domain name where your database server is hosted.
User	Database server user name
Password	The password of the database user
Database	Choose the appropriate database where you wish to dump the data.

ODBC CONNECTION CHECK

The connectivity can be checked by following the below listed steps.

On the server navigate to Control panel -> Administrative Tools.
Double click on the service Data Source (ODBC).
On the User DSN tab you will find “dbsyncqueue” driver.
Double clicking on the “dbsyncqueue” “Data Source Name” driver will open up a pop-up as shown in below screen.
Click on Test button which pops up connection successful.

...