One thing to be aware of is the supported language functions/commands through the ODBC driver if you are using triggers/stored procs.
Check the DRVVFP.HLP file for more info - there is a list of supported commands/functions, and also a list of unsupported commands/functions.
The info in the file pertains to VFP3 and possibly VFP5.
There is no mentions of INDEXSEEK for example.

Hope this helps

Jason