Hi Geof !

Ad.1. It is not correct.
Ad.4. You need to install VFP runtime on each client computer that run your application. MSDE you need to install on one choosen computer.
Ad.5. As far as I know MSDE limits is 5 users and not 5 connections.
If number of the users is greater MSDE performance will degrade.
I read that in practice the degradation is visible if number of the users is geater than 10-15 depended on application.

If you want to limit network trafic and you do not need extended capabilities of SQLServer you can try to use terminal services in Win2000 server. It is much more easier than switching to client-server technology.


>Hi
>
>I have never developed anything using SQL Server but am trying to cut the amount of traffic on a network and am unsure of how exactly things hang in VFP with regard to ODBC and SQL Server.
>
>It seems to me that I can achieve most of what I want by using remote views and ODBC. I have made an assumption that in using and ODBC connection and remote view that the view is made on the host where the data is stored but am unsure whether this is correct.
>
>1) Is this assumption correct?
>
>I can create ODBC connection and run a remote view without having a SQL Server.
>
>2) What then runs the query on the host?
>3) Are there limitations of utilising such a method?
>
>I guess what I am trying to figure out is what the benefits of going to a product like SQL Server 2000 are over just creating ODBC connections and using them instead as SQL Server 2000 would appear to be a costly exercise.
>
>I have been told (thanks Sergey) that the "Microsoft SQL Server 2000 Desktop Engine (MSDE)" that is shipped with VFP7 is a trimmed down version of SQL Server optimized for 5 user.
>
>4) Does that mean I would need a copy ove VFP installed at each site???
>5) Does that mean a maximum of 5 ODBC connections at any one time or just that it would degrade
>
>Regards
>Geoff Scott