I've been trying to figure this out for a while.
I've got an app. that calls a method of an out of process server that
returns a recordset object e.g.

Server Object
-------------------
Public Function GetMyRecordset(byval sQuery$) as Recordset

Dim recRes as Recordset

    Set recRes = MyDb.OpenRecordset(sQuery)
    set GetMyRecordset = recRes

exit function

I call this object method from within my application in the normal way e.g.

dim resReturnResults as Recordset

    set resReturnResults = objMyObject.GetMyRecordset(sMyQuery)

There is no error generated at either end, the recordset gets created in
the
server, no problem.  But the object doesn't get returned i.e.
resReturnResults
doesn't get instantiated.  I can't figure out what I'm doing wrong!

Any ideas ?

Thanks,
Steve

Have you tried changing from a public function to a public property?  I pass
a fair bit  of info via public properties (haven't tried recordsets yet,
though).

Steve,

I do not use this form to pass data back and forth.
I recall reading and then later testing the following:
Use a Variant type to send and return data instead of Recordset. Once you
receive the Variant variable, then you can cast it (by equating it to) to a
Recordset and manipulate the data you want.

Regards,
Sami.

Newleaf wrote :