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 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 MySQL ODBC Connection.
You can safely install both and create two 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.
However, if you are using a 64bit application, such as the 64bit version of Excel, you will need to install the 64bit MySQL ODBC Connection.
You can safely install both and create two 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 MySQL ODBC Connector can both be downloaded from this link
An older 5.x version is included for legacy compatibility, and a newer version 8.x is included for newer application connections such as Excel with Office365.
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
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
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
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 ...