visual foxpro ODBC driver -- unsupported commands??

[kakmouth]

I'm attempting to run a program (.prg) via an insert trigger in visual foxpro by inserting into that table from SQL server which is connected to the vfp table by linked server. The problem is that running a .prg from the trigger procedure returns an "unsupported command" error. In fact there are several commands (including the use of macros) that return the same error.

Is there any way around this?? is there perhaps an updated ODBC driver out there?? Or perhaps another way to run a .prg??

any suggestions would be greatly appreciated.

thanks. mike.