Selim,
You need to make sure that if you're using ODBC, the VFP ODBC driver needs to be installed on the actual SQL Server machine that is linking to the VFP data, as well as the DSN being created on that server itself.
I have this set up on our server here at the office and it works like a charm.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer