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.
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.
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
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 ...Power BI example with FactoryWiz data
Create a MySQL database user for by following these instructions https://kb.factorywiz.com/portal/en/kb/articles/create-readonly-user-for-large-screens Then create a System DNS on your computer by following these instructions ...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 ...