hi,

The Fox is just the client, it use the COM only. The access rights should be ok since I could retreive data from other COM if the parameter is not a ADO RS.





>hi,
>
>I need to pass the RS since I use the function's return value to indicator extra information (like, operation success or not, no. of records, etc).

You can get the number of records from the RS itself. IMO, this isn't a good design and limits things in your application.

>
>The sample I write is only for test purpose. Moreover, my COMs are used RS to communicate with each other. I can't change the COM since my VB program are working fine. Actually, I think the COM should be working both in VB and VFP. But now it's seem VFP have some problem in accessing the COM in MTS.

Does the Fox component live in MTS? Does it have the proper rights to access the data?
Craig Berntson
MCSD, Microsoft Visual FoxPro MVP
Salt Lake City Fox User Group
Tech Articles and more on my web site
www.craigberntson.com