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.
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: 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.
Please follow this article to create a new ReadOnly user.
Steps for installing ODBC Connectors
- Download the MariaDB/MySQL MS Windows 32-bit ODBC connector version 3.2.4 or higher, and install it.
- Click on the windows button, type in ODBC and select the 32 bit option
- Select SYSTEM DSN TAB
- Add, then select MariaDB ODBC 3.2 Driver
- Data Source Name = CyclesDB
then click Next - Server Name = IP Address of your server
- Port should be 3306
- User = the ReadOnly user name that you created in the MySQL database before proceeding with these instructions
- Password = the password created during the process of creating the ReadOnly user in MySQL database
- Then click the Test DSN button and you should get a message of "Connection successfully established"
- then select the Database from the dropdown list: FactoryWiz
- The keep clicking the Next button until you see the Finish button and click the Finish button.
If the Test Connection fails, check the following:
- You can ping the server IP (if Ping is enabled on the server)
- Firewall Rules are in place to allow 3306 on both server and client in both directions
- The MySQL readonly user account is valid
NOTE: if you are configuring a 32bit connection, the 64bit options will be disabled (Configure button will be greyed out)
If you are configuring a 64bit connection, the 32bit options will be greyed out.
You need to select the correct bitness per connection
If you are configuring a 64bit connection, the 32bit options will be greyed out.
You need to select the correct bitness per connection
Related Articles
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 ...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 ...