>I have two computers running Windows 95, connected via
>peer-to-peer TCP. I read the book 'Using VFP 3.0', and it only
>explains the use of ODBC, and establishing connections...
>so I created a test database about 1 million records
>in one computer (Using Foxpro DOS), then running VFP 5.0
>on the other computer, established a connection and a
>remote view...
>Isn't this setup incomplete? I thought that I need a
>database server on the remote side of the computer. And
>do the ODBC need to be installed on both computers?
>Can VFP serve as database server? What is the mechanism
>by which the two computers pass database-manipulation
>commands?
VFP can be used to simulate a C/S environment. Let's say that you have some VFP files sitting on a server. When you run teh query, data is passed from the server to the workstation and the query is processed on the workstation. In a C/S environment, the query is processed on the server and only the needed data is passed back to the workstation. To simulate a C/S environment in VFP, you need to write a query processor that runs on the backend that will accept a query from the workstation and then process it.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer