2022
The first and foremost step is to setup the ODBC driver on the server where Sage 100 is hosted.This section should aim to give new users an understanding of how to setup the ODBC bridge that would establish the connection between Sage 100 and your staging db.
Follow the below instruction for setting up ODBC.
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. |
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” driver will open up a pop-up as shown in below screen.
Click on Test button which pops up connection successful.