>A couple of questions, if you have time.
>
>1) Is there a speed penalty when using ODBC is this way?
>2) Do you know if your solution is applicable to other backend dbs like Oracle?
>3) What do I gain by using SQL server over VFP tables? Am I reducing the network traffic? It seems that SQL Server will allow much larger table sizes. If there is a whitepaper on the subject, could you let me know?
>
>Thanks Jeff.

I don't have the answers you're looking for here, but this has been my experiance:

1. Speed: I am converting applications from IBM DB/2-Query Manager applications running on desktop 486s to SQL Server/VFP applications using ODBC and TCP/IP. The VFP/SQL Server applications are much, much faster. How the speed compares to other types of applications I do not know. Using parametized views helps.
2. It should work with Oracle, SQL Server, VFP databases, etc. Just change the connection to point to the correct backend. There are some issues such as in SQL Server there is no date only field type, its a datatime field type. So in my remote views that have date fields I have to change the properties to change the field type from datetime to date.


Jeff