>I'm Using OLEDB provider from within VFP6. Here is a sample stored procedure:
>

>CREATE PROCEDURE crud_customers_create
>    @custName    varchar(254)
>    ... etc
>AS
>SET NOCOUNT ON
>INSERT INTO CUSTOMERS (custName, etc...)
>    VALUES (@custName, etc...)
>SELECT 'Any message here' AS 'message'
>

>
>In VFP:
>

>oRs = oCmd.execute && all parameters have been set
>if !(oRs.eof())    && crash and burn here...error:  "Operation is not allowed
>                          && when the recordset is closed"

>
>The record is inserted into the table by the SP, but I cannot get any recordsets to return to the client. It doesn't matter what I try to SELECT...no enchilada.
>
>Note: This problem does not happen if I use the ODBC driver instead of OLEDB.
>
>Thanks,

Steve;

I am not sure but VFP 6.0 and OLEDB may not be made for each other. VFP 7.0 includes OLEDB, but I am not sure about the compatibility with VFP 6. Maybe someone else has "The" answer.

Tom