Testi, Anthony L (UseTemp) wrote:
>This is a beginner's question, but I want to double check myself. Is there
>a way to link somehow to a copy of VFP running on a remote computer and
>request a cursor sent back. For example I can do that with VFP and MS-SQL
>via ODBC.
>
>I'm thinking that the remote VFP must look for a file/record in a table etc.
>that contains the request, process it, place a XML/text file/etc. in a
>shared directory, and maybe set a record in a table. The local program must
>wait for the results read it in, and translate into a cursor. I am aware
>that the remote VFP program can only handle one request at a time while
>MS-SQL can handle many.
>
>Is there a much simpler process then the one I just outlined?
>
>Anthony
>
Hi Anthony,
You might give Openlink a try. There web site is:
http://www.openlinksw.com/
They have software that acts as a back end server to many databases
including VFP. With Openlink broker you can access your remote VFP data
in the same way you can access MySQL or MS-SQL
Also, if no firewalls are involved, remote access services is running,
and proper privileges are in place, you can connect to a VFP
database/table over the internet using a path statement form the VFP
command window something like:
use //68.15.242.97/C/data/001/mytable.dbf
If more security is needed, you can use a Virtual Private Network (e.g. VFN)
LelandJ
©2003 Leland F. Jackson, CPA |
