>Take a look at mskb#Q299820 'HOWTO: Execute a Stored Procedure in a VFP Database with the VFP OLEDB Provider'.


Also make sure that CommandType set to adCmdText (1) or to adCmdUnknown (8), and not to adStoredProc (4). Visual FoxPro requires that stored procedures have open and close parentheses "()" at the end of the stored procedure name. However, ADO removes the parentheses from the end of the stored procedure name when you use adStoreProc.

>
>>Hi folks,
>>
>>It is possible to execute stored procedures (stored in DBC files) through VFP OLE DB provider???
>>
>>I want to access data stored in a DBC file, from another non-VFP application, and my goal is to execute the procedures, but I just get this error message "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for Visual FoxPro: One or more errors occurred during processing of command..."
>>
>>But executing a simple query like "select * from customers", then it runs OK.
>>
>>Any idea??
>>
>>TIA,
>>Dr. Programejos