Most Recommended Resources

These are some of our favorite tools or downloads that will be helpful. Some of them are FREE and some are paid.

Disclosure: Some of the links are affiliate links, and at no additional cost to you we will earn a small commission if you decide to make a purchase. We recommend you only purchase these products if you believe they will help you achieve your specific goals.

RECOMMENDED WEB HOSTING PROVIDERS:

MySQL:

MySQL Workbench Download
MySQL Server Download
MySQL Connector/ODBC 8.0 Download (note: don’t select 32-bit or 64-bit based on OS version, but based on Microsoft Office version installed)


' Connection string sample for MySQL Connector/ODBC 8.0:
ConnectionString = "DRIVER={MySQL ODBC 8.0 Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

' Connection string sample for MySQL Connector/ODBC 8.0:

ConnectionString = "DRIVER={MySQL ODBC 8.0 Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

MySQL Connector/ODBC 5.3 Download (note: don’t select 32-bit or 64-bit based on OS version, but based on Microsoft Office version installed)


' Connection string sample for MySQL Connector/ODBC 5.3 (should work also with MySQL Server 8.0):
ConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"

' Connection string sample for MySQL Connector/ODBC 5.3 (should work also with MySQL Server 8.0):

ConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;"