>I also faced the similar problem.
>Regarding ADO, I think currently VFP does not support ADO. So you have to create an ActiveX in VB or VC that will access the database using ADO. Then use the activeX in VFP6. There is an article on usin ADO in VFP in the December 1998 issue of FoxTalk.
>
>There is another tecnology called Remote Data Service (RDS). Microsoft has used it in Anomaly Tracking Software (ATS Web). This is a software written in VFP6. I think its shareware. You can down load it from MicroSoft site.
>
>For further enquiry contact me at:
>
>Bhavdeep@konstruct.com
>Bhavdeep@hotmail.com

In addition to Colin's references, see the ADO Jumpstart whitepaper on the VFP home page.