You cannot call VFP stored procedure directly thru ODBC. You have to use OLE DB provider for VFP that comes with VFP 7.
>I am developing an n-tier application. For now, I'd like to have my VFP middle tier use ODBC to connect to a VFP datasource. The back-end data will have several stored procedures that my middle tier will need to call.
>
>How do I call a stored procedure in a VFP database via SQL Pass thru. As a work-around, I put a one-row-table, called SP, in the vfp database and use SQLEXEC to send a query to the DB with the stored procedure as a column. Like this:
>
>SQLEXEC(nHandle,'SELECT SP_TEST() AS result FROM SP','SPResult')
>
>Although this works, it seems kind of silly. There must be a better way.
--sb--