MySQL 8.0 ODBC Connection String Issue

[John Peter Paredes]

Posting it here to help my fellow newbies resolve this issue should they come to this in the future.

GIVEN :

My Operating System : Windows 10 x64
My Programming Language : Visual Foxpro 9.0 SP2
My Database : MySQL 8.0.12
My ODBC : MySQL ODBC 8.0
using Sqlyog8 because workbench took forever to
import a 20mb .sql database backup file from mysql
5.0

ISSUE : When connecting from FOXPRO to MYSQL using SqlStringConnect (by way of
ODBC) the connection would fail. even when your ODBC driver is spelled
exactly the same with the one in your ODBC Driver list in
Administrative tools.

Found Cause : When downloading and installing the ALL-IN-1 installer for MySQL the installer will decide to install a x64 ODBC Driver for you because it detects your OS is 64 bit. but since Foxpro is 32bit it wont be able to connect. i had to download and install a 32bit version of the ODBC separately and install it. it should show up on your Administrative Tools -> ODBC x86 list. now it connects. thanks