>>James,
>>
>>This doesn't make sense to me. Whether you use the VFP ODBC Driver or Native VFP the data engine is the same, and it runs on the work statation, so wouldn't network traffic be the same? Have you tested this with a netowrk sniffer?
>>
>
>It actually makes sense to me, becuase in a traditional enviorment where files are opened etc, the entire index files have to move from the 'server' to the client work station, moving these larger index files, the first time, can take quite a while,and bog down the network.
>With odbc, all you are actually sending over the network is the sql statment, and all you get back is the result... the index and database files, which are stored on the server, never get actually moved to the client workstation.
>
>Bob Lee

Bob,

With the VFP odbc driver, who are you sending the SQL statement too? It is actually the ODBC driver itself that is the "data engine" as opposed to using SQL Server the ODBC driver is only a conduit for the commands and data.

BOb