You cannot call VFP stored procedures through VFP ODBC driver because this functionality is not supported by the driver. As a workaround, you can create a table with a trigger and call stored procedure from that trigger. You can use fields in that table to pass parameters into stored procedures. Check also How To Execute a Stored Procedure in a VFP Database with the VFP OLE DB Provider mskb #299820.


>
>Can somebody give me an example how to call an store procedure in a DBC using SQLEXEC.
>
>the DBC will be remote so I need to stablish the connection and then execute the SQLEXEC but i dont find any good example how to do it in VFP databses. All the examples are to SQL Servers.
>
>for example if I include the following syntax get different error,
>
>databasename!procedurename unreconize command
>
>Databasename.procedurename zyntax error or security error