Specified key was too long; max key length is 767 bytes

Getting this error "Specified key was too long; max key length is 767 bytes" from your MySQL?

Here is the solution:

• Simple, just upgrade your MySQL to at least version 5.7.30.

You may download the GA releases from here: https://dev.mysql.com/downloads/mysql/

The 'vfpoledb.1' provider is not registered on the local machine.

Not able to find the solution for this error message "The 'vfpoledb.1' provider is not registered on the local machine."?

Here is the solution:

1. Download the msi file from here, https://www.microsoft.com/en-us/download/details.aspx?id=14839, and make sure you install as Everyone. If you choose Only Me, you will hit the same error message.
2. Build your application, regardless it is a web application or desktop application, in x86 mode.

Happy coding!