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 articleConfiguring 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