RE: VFP and SQLServer 2005 Std Edition

>>for odbc do I have to install a sql server odbc driver ???<<

The SQL Client is installed when you install SQL Server 2005. It can be installed separately too

(which you need during your deployment).

>> Plus I read there are two ways to go views & sql pasthrough. Which one would be easy for a

desktop application. No web.<<

Easy is a relative term <g>. VFP 8 and 9 also have CursorAdapters. One other thing to consider is

you can mix and match them in the app. For instance you can use Remote Views or CursorAdapters for

data entry forms because they simplify the CRUD operations and metadata management with a small

sacrifice in performance. Then use SQL Passthrough for reporting and analysis because it provides

you simplified and fully flexible querying. Or you can standardize on one approach to have a

consistent data management strategy.

Lots of choices.

Rick

White Light Computing, Inc.