SQL Server is compatable with all of those. You'll always use a connection. A connection simply connects the application to the database, then queries and data will be passed through the connection. You won't use native VFP SQL at all. You can use SQL Server SQL, but you'll most likely see the best performance from using stored procedures. You may also want to look into use OLE DB/ADO instead of ODBC as it may provide better performance.


>Dear all
>
>I'm using VFP8 as my front-end, and I'd like to use SQL2000 as the back-end. What's the best way to share data between the apps? I know about setting the ODBC connection, it's more from the perspective of the VFP front-end.
>
>Do I used remote views or connections, should I use native VFP SQL commands or should I use stored procedures within SQL? The intention will be to have multiple front-end's, i.e. web applets and some VB app's too, so the back-end has to be compatible with these.
>
>Thanks in advance.
>
>Regards
>
>Derek