>I have a situation where a client moved data from SQL 7.0 with no service packs to another server running SQL Server 7.0 with service pack 2. Both servers are running NT 4.0 with service pack 4.
>
>Although the ODBC drivers on all workstations have been redirected to the new server, and each connection tests successfully in the ODBC setup, VFP applications that try to use these connections are all failing.
>
>Each VFP application runs successfully when run directly from the new server. We have installed the newest MDAC file on all workstations, with no change in results.
>
>Is there something else that should be checked for ODBC or SQL Server (or VFP for that matter)?
>
>Thanks!
>Margaret

The latest MDAC (2.7) does not include the latest VFP ODBC driver, download it from http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp.

It could also be a permissions problem, if the SQL Server authentication setup is different.