>Hi everybody,
>
>I have a little problem wich I think might become a big problem. Here it is:
>
>We are building a multi-user application, where the databases resides at a central location like a Novell server. Some users are connected to the network with a network interface card or NIC (10 mb/s) while some others are connected using an ISDN link (and I think some are connected using modems too). The applications are executed on each workstation and the applications are using FoxPro 2.6 SQL-select commands the retreive the information from the databases located on the server. The problem I think we're gone have is that the users on ISDN will wait a very long time before the query is done since a lot of data will be retreived by the workstation in order to execute the SQL-select command. And we don't want this to happens. I've heard of ODBC and SQL server, I think SQL server would be the solution since most of the selection will be done on the server running sql server. Am I right? Is there is another way to look at this problem? Of course we can't demand the users to change their
>network. Can foxpro windows 2.6 can use a SQL server and how?
>
>Thanks in advance
>
>François Dagenais
>Member of the Montreal FoxPro user group!

Bonjour François,

There's something that you might try that involoves VFP only and with the money you'll spare you'll have some time for experimentation....

What if you consider your FoxPro data on the server as remote data and access it with VFP ODBC driver through a connection? With VFP you'll be able to build remote views, and with the new version of the VFP ODBC driver you'll be able to create parameterized views.

José