The Web-Server is hosted remotely on a Web Hosting company which provides services like "multiple MySQL" databases, FTP, Email accounts, etc.
I basically want my VFP 9 applications installed on several remote locations to access the central MySQL database in the Web Hosting company via the Internet connections.
I understand the 2 books you recommended was published more than 10 years ago for VFP 6 and was wondering whether it is still relevant today given the rapid change of technology and if VFP 9 has already implement similar or new features mentioned in the 2 books.
I would gladly buy those books if it is still relevant today on VFP 9.
True, both books were written about 10 years ago.
But there haven't been many VFP books put out since then of any kind.
In general, you cannot directly connect an in-house VFP application to a database that resides on the web.
You will have to use additional 'tools' to support that connection.
Generally that involves one or more 'tools' on the Server-side and possibly another 'tool' on the Client-side (although this is not as likely).
My work of this type has not been extensive, but has involved having VFP make SOAP or HTTP Post/Get Requests from the Server (supported by Server-side 'tools') And the response times varied greatly depending on how the Web traffic in-general was at the time - but it was typically no where near as quick as utilizing an in-house database (VFP, MS SQL Server, or MySQL Server)
Yes over the last 10 years the variety of 'tools' have evolved, but most of the early ones still exist and work.
Let me add one more related comment that I have 'lifted' from another very knowledgeable guru's posting on another forum site.
SQL Server or MySQL databases can be hosted [on the Web] allowing remote access, which includes access from a desktop client. You have to look for hosters allowing that, mostly hosted database access is limited to localhost, meaning you can only query directly at the server.