VFP Stored Procedures are not designed to return recordsets like SQL Server. In VFP, you are using a Data Session and openning cursors in the session. When you use the OLE DB provider, it doesn't understand Data Sessions.
Also, I would highly recommend using the OLE DB provider that ships with VFP 8. It has been revamped to provide better compatablity with ADO.NET.
>Dear ut-user,
>
>Is it possible to return a resultset from a vfp stored procedure?
>
>I am using the vfp7oledb provider and I call the sp by using c# like this:
>- CommandType = CommandType.Text;
>according to ut-users there seems to be a problem with the StoredProcedure enumeration value)
>- CommandText = "getClientDetails(?)";
>I only use a VarChar param, because according to ut-users there seems to be a problem with other param-types.
>
>The sp works fine when I call it from my vfp command window. It goes all bad when I call it from my Asp.Net page. The only thing I can get it to retur in:
>return_value=true.
>
>Sorry for not including the proper code, but I left that at home.
>
>Thanks for looking into my problem!
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi