>I am trying to syncronize two remote VFP databases and figured I could have one connect to the other via ODBC and perform the updating. But, everything I have seen about DBC and remote views seems to put VFP as the client only, not as a server. Can the ODBC driver for VFP allow VFP as a server?
>
>The two machines running VFP apps are connected via ISDN and TCP/IP, and the tables are large, so I dont want to open the databases as on a network drive. Presumably, one of the advantages of ODBC is that the SELECTs, etc. are processed on the server, so network traffic is less than with client side processing.
Joe
I have not done a remote view to a VFP source but I do not see why you cannot do it. Look under:
CREATE SQL VIEW [ViewName ] [REMOTE]
It is really just a bidirectional SQL statement (updateable view). I would stay away from ODBC -- heard too many horror stories.
HTH
Tom