On 3/17/10 12:33 PM, Stephen Russell wrote: > On Wed, Mar 17, 2010 at 1:49 PM, Michael J. Babcock, MCP > <[email protected]> wrote: >> Client wants to put the VFP database folder and files on their server in >> SomeWhereElse, PA and have a workstation in SomeRemoteTown, PA work over >> the VPN. So basically, can the app reside locally and access the data >> folder over the VPN? Or must I locate everything on the VPN? Or tell >> him this won't work? > ----------------------- > > Very sucky response is what you will have.
Yep. > Time spent here would be better to suggest real C/S data storage and > consider using local cursors at best. Caveat is that the data is > exposed on the web. So customer names, $$,& details could be picked > by others. Well, it would go inside the encrypted VPN tunnel, but you do still run some risk of your data becoming exposed, especially since SSL keys are becoming less and less trustworthy of late. But you'd run that exact same risk going over a web service or something. I've found acceptable performance with properly-structured queries (ie, something better than SELECT * from table LIMIT 2000) from VFP going over the VPN to a MySQL database. Not like being there, but not horrible, either. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

