Hi!

You require to use the recordset marchalling between COM objects. This should be a client-side ADO recordset, something like following:

rs.CursorLocation = adUseClient
rs.Open ...
rs.ActiveConnection = Nothing
rs.MarshalOptions = adMarshalAll

Above way you make the disconnected recordset. Only such kind of recordsets could be passed between COM objects.

HTH.


>I have a com server written in VFP that employs VFPCOM to convert between cursors and recordsets.
>
>My server method - getrecordset() - to return a recordset to the client works fine whether the client is written in VB or VFP.
>
>The method -passrecordset()- that takes a recordset as a parameter fails when the com server runs in a VB client (see code snippet below).
>
>*****
>set myserver = createobject("myserver.myserver")
>set rs = myserver.getrecordset
>Call myserver.passrecordset( rs )
>*****
>
>I have checked the parameter in the VFP server passrecordset() method - it is an object but doesn't appear to be an adodb.recordset object, i.e. i cannot access any methods of the recordset object.
>
>When the client is VFP I can access the recordset object no problem inside this method.
>
>Any help with this problem would be greatly appreciated
>
>Damien Byrne
>Kaleida Ltd