Without more details about the class, sounds like a statefulness issue that would present itself only on MTS/COM+.

Why don't you just use the recordset object directly? Or if you're not doing batch updates use the connection object with a client-side cursor location to return the recordset.

loConn = CreateObject("ADODB.Connection")
With loConn
  .CursorLocation = 3 &&adUseClient
  .ConnectionString = "myconnectionstring;blahblah;"
  .Open
EndWith
loData = loConn.Execute("select * from mytable")
loData.ActiveConnection = .Null.
Return loData

>Hi,
>
>I build a VFP multi-thread DLL (the app server), and i need setup the clients. So, i chosse to use MTS/COM+ for install a package with it and export it to setup the clients. The cliens connect to the server but no data is returned...
>
>
>- I use Disconnected ADO RecordSet for get the data and update it...
>
>For example:
>
>Function GetData
>
> Local loData
>
> loData=CREATEOBJECT('TADORecordSet')&&TADORecordset encapsulate a ADO Recordset in a VFP Class
>
> loData.Open('SELECT *...
> loData.ActiveConnection=.NULL.
>
> Return loData
>endfunc
>
>This work fine if is not installed under MTS (the recordset return 11 records), but when is installed under MTS the recordset return 0 records!!!
>
>How fix it?