IIRC, the current VFPCOM came out after the initial release of VFP8, so maybe they are still working on the VFP9 version. Will CursorAdapter do what you want? I know it can work with ADO, but I'm not sure if it will create a recordset from a cursor. If not, there used to be a DBF2RS.prg floating around that you might be able to find.
>Hi,
>
>I have a vfp com object (accessed from an asp page) that I am changing from vfp 7 to vfp 9 (to add new features).
>
>In numerous places I take a cursor and convert it to a recordset and then return the recordset. Like the following:
>
> SELECT * FROM student WHERE istudentid=813 INTO CURSOR _S
> Local oRecordset, oVFP
>
> oRecordset = Createobject("ADODB.RecordSet")
> oVFP = Createobject("vfpcom.comutil")
> oVFP.CursorToRS(oRecordset, "_S")
> Release oVFP
> Close Databases All
>
> Return oRecordset
>
>When the COM object is compiled in vfp 7 it works. When it is compiled in vfp9 it doesn't; the asp page will just hang and the line in the vfp com object that it gets stuck on is
>
> oVFP = Createobject("vfpcom.comutil")
>
>The function works when compiled into vfp 7 and when I run it from the command window in vfp9, but when an asp page is accessing it, it just hangs.
>
>I have downloaded and installed the newest version of vfpcom.dll from microsoft (says for vfp 8).
>
>
>Is the vfpcom not supported in vfp9?
>Is it because I have windows service pack 2?
>
>Any assistance would be appreciated.
>
>Thanks,
>Malonep
>
>(not sure if I put it in the correct category - the first time)