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,