VFPCOM.DLL is buggy. Even MS doesn't recomend to use it BUG: RStoCursor in Vfpcom.dll File Does Not Work with Certain Data Types mskb #Q262067.
There're a few files in the download section that can do it:
ADOGetRows.jcRStoCursor (ADO-VFP cursor) File #9916
OLE DB Library for Visual FoxPro (beta version) File #10002



>Hi!
>
>You can pass disconnect ADO recordset object to client. Then you can work with it as is, or convert ADO recordset to VFP cusor by using latest VFP OLE DB provider (there was a thread about this recently), or by using VFPCOM.DLL (used for VFP6).
>