>>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. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/026401c977eb$5bf829e0$13e87d...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
