MySQL Forums
Forum List  »  Connector/ODBC

MySQL 8.0 ODBC Connection String Issue
Posted by: John Peter Paredes
Date: August 17, 2018 08:03PM

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

Options: ReplyQuote


Subject
Written By
Posted
MySQL 8.0 ODBC Connection String Issue
August 17, 2018 08:03PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.