Installing MySQL ODBC Drivers for BI Connectivity in Windows
In order to connect to Dual Code's database, you may need to install the correct MySQL ODBC drivers.
Business Intelligence Connectivity is a premium service. For more information, please contact us.
Step-by-step Guide
1. Download the latest MySQL ODBC driver from http://dev.mysql.com/downloads/connector/odbc
Please keep in mind that you may need to ensure the connector version conforms to both the OS and application bit-level (32-bit vs 64-bit).
Typically the 32-bit version of the ODBC driver is the most compatible.
2. Create a system DSN using the 'ODBC Data Sources' application in Windows (choose the correct bit-level).
3. Click the 'System DSN' tab
4. Click 'Add'
5. In the select list choose your specific driver (ie: MySQL ODBC 8.0 Unicode Driver)
6. Fill the form with details Dual Code provided
7. Once filled out, click the 'Test' button to verify connectivity
8. This driver should now show up in any ODBC compatible application