You could start by downloading my CA Builder and CA Examples from http://www.mctweedle.com [then click the FoxPro Tools link]. I have examples for ADO, extensive PRG file comments, etc., for VFP tables, SQL Server and Oracle. There should be a PRG file called testado_msde.prg file that should help you.

If you are setting the DataSource propery visually [i.e., in the property sheet], you might try putting an EQUAL sign before the value -- =oRSObject instead of oRSObject

>I have a subclassed cursoradapter using ADO. I create it the object and it works. However, any successive creations of this cursoradpater class, on the same table or a different one, returns an error when you do a .cursorfill():
>
>ADODB.RECORDSET: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
>
>CLEAR ALL clears this condition. Releasing the object variable for the first cursoradapter does not. I am using SQL Server.
>
>The condition occurs whether or not a .cursorfill() is done with the first object.
>
>Has anyone run into anything like this before and make suggestions as to a solution?
>
>Thanks,
>
>Dennis