In my notes Devcon sessions, I give a fairly comprehensive demo of RDS in the context of COM and Automation. One thing to note that RDS really uses the ADO interface when it is all said and done. RDS actually makes use of a different local OLE-DB Provider, the MS Remote Provider. The MS Remote Provider in turn facilitates communication with a remote data provider. There are some configuration issues with RDS. I have found that at times, you need to totally reinstall things to get things working properly.

In terms of using your own business object, could you elaborate on that a bit more?

>I know this is off this topic.........
>
>Have you had any luck with RDS and VFP data? I have noticed most of your papers and Devcon Sessions deal with ADO only. I am starting an order entry Intranet/Extranet app and would like your opinion of RDS. Or if there is a better solution than RDS.
>
>RDS seems easy to implement, but I have not had any luck with it yet....Keep getting "Internet Server Error" when I try to use my own business object instead of the default RDS business object.
>
>>The issue you are dealing with stems from the fact that your recordset does not have a key that uniquely identifies a record. I published a tip about this 2 or 3 years ago in FoxTalk. If you create a local view/remote view in which the field specified as the key is not unique, changes made to 1 record with that key will propogate to all records with that key value.
>>
>>This issue has nothing to do with bookmarks. In fact, if your cursortype is set to static (3), bookmarks are in fact supported.
>>
>>The solution, make sure you both have a primary key in your tables, and for the table you wish to update, make sure that key is included in your ADO Recordset.
>>
>>
>>>John Hi,
>>>
>>>Here is another problem with ADO using VFP DBF's.
>>>
>>>I execute an Rs.Open "SELECT " statement and get a record set.
>>>
>>>I then update most fields only one record from that recordest and perform an Rs.Update.
>>>
>>>If the record set happens to contain more than one record that are exactly the same (for example all fields are blank), then all the records are updated and thereby I get duplicates in the table even though my intention was to change only one record.
>>>
>>>I believe that this may have something to do with the fact that the OLE-DB provider (in this case MS VFP) does not support bookmarks (or record numbers in this case).
>>>
>>>Am I correct in this assesment and is there a workaround?
>>>
>>>Thanks
>>>
>>>Costas