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.
- 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
Related Articles
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 ...
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 ...
FactoryWizTV Application
Configuring FactoryWizTV FactoryWizTV Application Product Name: Flipper Type: Windows Application Framework: .Net 4.0 Current Version: 24.1.0.0 Purpose To rotate different applications at a set interval on a single display. This application is ideal ...
12.1.1 Setup and Configuration
To access FactoryWiz TV you will need to install it on a Windows PC with .NET 8 installed. It must also be on the same network as the FactoryWiz server. FactoryWiz TV can be launched from its desktop icon. By default it will look like the image ...
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 ...