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 ---
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]
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]
My brain doesn't want to work, and I don't want to end up re-inventing the wheel.
I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length.
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thank you!
IRCC VFP has a wizard for that.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Vince Teachout Sent: Wednesday, March 10, 2021 11:38 AM To: profoxtech@leafe.com Subject: CRS and Generating a Data Dictionary.
My brain doesn't want to work, and I don't want to end up re-inventing the wheel.
I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length.
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thank you!
Also, iirc, Stonefield Database Toolkit was made open source awhile back. Even at cost, it's super worth it. Provides great documentation too. I work with VFP databases with one client and it makes database management so much easier than without it.
On 3/10/2021 11:44 AM, Richard Kaye wrote:
IRCC VFP has a wizard for that.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Vince Teachout Sent: Wednesday, March 10, 2021 11:38 AM To: profoxtech@leafe.com Subject: CRS and Generating a Data Dictionary.
My brain doesn't want to work, and I don't want to end up re-inventing the wheel.
I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length.
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thank you!
[excessive quoting removed by server]
SDT would definitely be a better choice if you have a copy handy, Vince.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of MB Software Solutions, LLC Sent: Wednesday, March 10, 2021 11:47 AM To: profoxtech@leafe.com Subject: Re: CRS and Generating a Data Dictionary.
Also, iirc, Stonefield Database Toolkit was made open source awhile back. Even at cost, it's super worth it. Provides great documentation too. I work with VFP databases with one client and it makes database management so much easier than without it.
On 3/10/2021 11:44 AM, Richard Kaye wrote:
IIRC VFP has a wizard for that.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Vince Teachout Sent: Wednesday, March 10, 2021 11:38 AM To: profoxtech@leafe.com Subject: CRS and Generating a Data Dictionary.
My brain doesn't want to work, and I don't want to end up re-inventing the wheel.
I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length.
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thank you!
SDT is the better way to go, but you could just loop through ADatabases(), ADBObjects() or AFiles() for free tables and then use AFIELD(). Or DISPLAY STRUCTURE and parse the result, but that would be wrong.
https://hackfox.github.io/section4/s4g666.html https://hackfox.github.io/section4/s4g284.html https://hackfox.github.io/section4/s4g292.html
On Wed, Mar 10, 2021 at 11:38 AM Vince Teachout vinny@caracal.net wrote:
My brain doesn't want to work, and I don't want to end up re-inventing the wheel.
I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length.
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thank you!
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]
On 03/10/21 11:37 AM, Vince Teachout wrote:
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thanks, all! I'll look to see if I still have SDT, but if not, I do recall having looped through ATables before, and may still have that code somewhere. Thanks again!
https://doughennig.blogspot.com/2020/01/stonefield-database-toolkit-is-now-o...
https://github.com/DougHennig/StonefieldDatabaseToolkit
On Wed, Mar 10, 2021 at 3:38 PM Vince Teachout vinny@caracal.net wrote:
On 03/10/21 11:37 AM, Vince Teachout wrote:
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thanks, all! I'll look to see if I still have SDT, but if not, I do recall having looped through ATables before, and may still have that code somewhere. Thanks again!
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]
That's it...knew I heard that right. Thanks for the links, Ted!
On 3/10/2021 3:47 PM, Ted Roche wrote:
https://doughennig.blogspot.com/2020/01/stonefield-database-toolkit-is-now-o...
https://github.com/DougHennig/StonefieldDatabaseToolkit
On Wed, Mar 10, 2021 at 3:38 PM Vince Teachout vinny@caracal.net wrote:
On 03/10/21 11:37 AM, Vince Teachout wrote:
I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this?
Thanks, all! I'll look to see if I still have SDT, but if not, I do recall having looped through ATables before, and may still have that code somewhere. Thanks again!
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]