Optimizing ODBC Installation for FactoryWiz Database Connectivity

10.2 ODBC Installation

If you wish to connect a computer on your FactoryWiz network to the FactoryWiz database for things such as Microsoft Excel, you can use an ODBC connector.

Normally we will install the 32bit MariaDB/MySQL ODBC Connector for things such as FactoryWizTV connections (as FactoryWizTV is a 32bit application).
However, if you are using a 64bit application, such as the 64bit version of Excel, you will need to install the 64bit MariaDB/MySQL ODBC Connection.
You can safely install both and create both 32bit and 64bit ODBC System DSNs with the same name and the operating system will select the correct one based on the bitness of the application using the connection.

The 32bit and 64bit versions of MariaDB ODBC Connector can both be downloaded from this link
The 64bit version of MySQL ODBC Connector can be downloaded from this link (there is no 32bit version of MySQL ODBC 9.0 driver)

The MariaDB ODBC drivers should be compatible with most older legacy applications. 
Please be sure to download at least version 3.2.4 or higher as that will ensure the DSN setup wizard will work correctly (not requiring SSL by default). 
However, for Office 365 64bit connections like Excel and PowerBI, you will need to use the MySQL ODBC Connector, as the MariaDB ODBC Connector has a known issue incompatibility with Microsoft Office 365.

Instructions for configuring the ODBC Connector can be found in this article
Configuring 32bit and 64bit versions of the ODBC connector are basically the same, you would just choose between the Windows ODBC Data Source (32bit or 64bit) to configure each DSN
Alert
Note that you will need to create a new ReadOnly user for the Connector. 
Instructions for creating a ReadOnly user can be found in this article

    • Related Articles

    • Installing an ODBC Connector for FactoryWizTV

      Configuring FactoryWizTV Installing an ODBC Connector for FactoryWizTV NOTE: You will need to create a new ReadOnly user in the MySQL database before proceeding with these instructions Please follow this article to create a new ReadOnly user. ...
    • 10.3.1 Connecting Excel with Office365 to FactoryWiz

      Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector. See ODBC Installation 1. Open Excel and create a new Workbook 2. Select DATA Tab and then select Get Data > From Other Sources > From ODBC 3. Select ...
    • 10.3.2 Connecting Excel Desktop version to FactoryWiz

      Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector. See ODBC Installation Open Excel and create a new Workbook Select DATA Tab and then select From Other Sources > From Data Connection Wizard Then select ...
    • Preparing for FactoryWiz Monitoring

      Preparing for FactoryWiz Monitoring FactoryWiz Installation This document is to help you understand the preparation which is required to ensure that your system deployment goes as smoothly as possible. We want to make sure that you have a good ...
    • FactoryWizTV Setup

      Configuring FactoryWizTV Setting Up FactoryWizTV This guide covers how to setup and install FactoryWizTV applications. You will need to: Create a database user account for the application to connect with. Install and configure the ODBC connection ...