Ditto to using MariaDB. If you'd like me to send you code of how I manage my connection handles, just email me a.t. mbabcock a.t. mbsoftwaresolutions doooot com.
Ever since I saw Bob Lee's presentation at WhilFest 2003 or 2004, I switched to MySQL (then later MariaDB) and never looked back. I still maintain Jeff Johnson's WWWC app for his client (RIP Jeff!) and that uses a VFP backend, but other than my Hockey Manager app I threw together recently for quick fun, I don't use VFP DBC/DBF backends for Production apps.
--Mike
On 2/26/2021 3:20 PM, Ted Roche wrote:
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]