Yes, you need an ODBC driver, and you connect using that. Install a 32-bit ODBC driver, and manage it with the 32-bit ODBC Administrator. You can set up and test a DSN in the ODBC Administrator and then copy the settings to a VFP SQLConnectString() if you'd prefer.
I don't use the Oracle MySQL, but rather MariaDB and their driver.
A great source of connection strings is: https://www.connectionstrings.com/mysql/
On Fri, Feb 26, 2021 at 1:30 PM Rafael Copquin rafael.copquin@gmail.com wrote:
I have been using SQL Server Express for years, both on local PC's and the cloud.
I am now considering using MYSQL for a new cloud app.
I downloaded and installed the MySQL Workbench and can connect to the cloud MYSQL database, directly from the WorkBench.
However, I was not successful in connecting to the cloud (or the local host for that matter) from VFP
Do I need to download and install an ODBC driver for this? If so,which driver?
A code snippet would be of great help
Thank you all in advance
Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]