Craig is correct. While security could be maintained using a VPN, there's also the problem of ODBC not being designed for web communications.
You can keep it simple, and webified, using a VPN and using oData (assuming it's Azure SQL, which is not MySQL). This gets you out of writing a web service endpoint to put on Azure.
The nfjson VFPX project might be of help in generating the oData Update string (which will be the "data" of the command). I've used the ChilKat http object to access web services: the error messaging is first-rate, and saves a lot of time both in development and production.
Hank
>Sorry, what part is dangerous, and what do you suggest doing instead?
>
>>Very dangerous. If it's open to you, it's open for everyone, including hackers.
>>
>>
>>>Hi. I feel a bit lost on this one. One of my clients wants to update data in a database stored "in the cloud", with Azure.
>>>It seems the database server is MySQL.
>>>How is the connection with Visual FoxPro set up? Is there a way to access the data with anything resembling a remote view? How do I set up an ODBC connection - or do I even need one?
>>>What additional information does my client need to find out about the service to which he subscribed?
>>>
>>>TIA,
>>>
>>>Hilmar.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement