Joe,

The VFP ODBC drivers doesn't support stored procedure calling.

You have two solutions.

1) Using trigers on a procedure table.
2) Building a COM Object

Marcel

>I need to call a stored procedure in a FoxPro version 5.0 database from Microsoft Visual Basic version 5.0. Any ideas on how this can be done? My stored procedure works fine when I am running VFP and call the procedure, but I cannot figure out how to call the procedure from the VB code after establishing a connection with the database.
>
>I'm connecting to the database from the client using an ODBC driver across the network, but I don't think this is going to be a problem.
>
>Joe