Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Boudewijn Lutgerink
 To: Walt Ehle
  Where is Walt Ehle?
 Virginia - United States
 Walt Ehle
Subject: RE: VFPServer?
Thread ID: 107144 Message ID: 107377 # Views: 75 # Ratings: 1
Version: Visual FoxPro 9 Category: 3rd Party Software
Date: Tuesday, September 19, 2006 8:59:04 AM         

> BL,
> For the un-initiated, briefly what is vfpserver and why would I want to use it?
> Thanks

VFP with its native database is NOT a C/S system, it is a fileserver system.
This means that if you write an app to be used on a network it will send you the COMPLETE file if you open a form with a file (or more files) in the DE. This means a heavy load on the network, especially if the files are growing... To reduce network traffic you could, of course, use REMOTE views (LOCAL views open the table as well in your Datasession) or, in the case of VFP8 and 9, the CursorAdapter (with a filter). That does reduce the NW traffic a lot already.

The point is still that the datafiles need to be visible, either on a local disk OR on a mapped drive, making it vulnerable and open to nosy users who try to find more than they are allowed to see anyway. This would mean en/de-cryption of data with all the speed reduction of accessing the data, one of the strongest points of VFP.

VFPServer is exactly that, a true server that can be approached by it's IP address. Because the server can be reached by its IP address it can remain INvisible to the users and so are the databases and DBF files.

The client can send a SQL - Select statement, or any other type of command for that matter, to the server that is executed by the server and the resulting Cursor is send back (encrypted) to the client. This means that the network traffic will be a lot lower and datasecurity is more easily possible to implement.

eg. You could send a username and encrypted password with every SQL-Select that is checked by the server BEFORE doing the SQL select...

As said, the vfpserver at www.vfpserver.com is restricted to VFP databases only, I would like to see the possibility to attach more types of databases. (And no, I am NOT thinking about SQL Server or anything alike, but more of the smaller ones.)

Boudewijn LutgeĀ®ink
If it ain't a Border Collie it's just a dog...