>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

MegaFox has some great chapters on this. The idea is to build a mediator application that handles requests for data so that you only need 1 connection to the database server until volume gets significantly larger than 5 users. Andy Kramek has an article about this too, I am not sure where to get ahold of the article since I only saw a print out.

Also there are some great point on the FoxWiki ... Check out http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server

MSDE is redistributable.