Troubleshooting connecting to MySQL in VBA

To connect to MySQL database we need to have the MySQL Connector/ODBC driver installed.

Virtual Form control is a 32-bit application, so you need to install the 32-bit version of the MySQL driver.

If you have 64-bit Office version you need to install both 32-bit & 64-bit versions of the MySQL driver so that Virtual Form control (32-bit) & VBA (64-bit) can connect to MySQL

You can get the download links and the sample connections strings from the Resources section on Virtual Forms webpage.

Here is the direct link:

https://www.virtual-forms.com/resources/