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.copq...@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]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/663836e7-7816-5ecb-1bba-86bf80c94...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
