MYSQL connection

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 connec

Re: MYSQL connection

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, bu

Re: MYSQL connection

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 dt 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.