>>Hey,
>>
>>Ok.. Given ODBC, ADO, and all the various methods of extracting data from a SQL 7.0 backend, what have you determined to be the "optimal" method.
>>
>>Given..
>>
>>1. A SQL 7.0 back end
>>2. A VFP front end (as an aside have you found Delphi or VB faster?)
>>3. Anything else inbetween to make things faster
>>
>>How do you deal with #3? Seems to me there are several paths here and I was just wondering where everyone landed.
>>
>>For example, do you use Intersolv's ODBC drivers or Microsoft's or ??'s
>>
>>Best,
>>
>>DD
>

IMHO --- Oops

We use nameless ODBC (M$ drivers) connections to connect to the database. All selects, updates, inserts, deletes (data Manipulation) are stored in SQL Stored Procedures. We use SQL pass through to pass only the minimal amount of information/data to SQL Server and let the server process the data. We do this for a very light weight frontend and minimal network traffic. Only the user interface is on the client side so the majority of changes/bug fixes occur on the backend and occur realtime. It would be no big deal to rebuild the front-end in any other (inferior) RAD tool. SQL Server must reside on a good box in this setup.