I would advise against using ADO. Microsoft has announced that ADO will no longer be supported on SQL Server. It's days on other databases will be numbered.
>From the nature of your questions, I'm thinking you may not have much client-server experience with VFP and a back-end database (?)
>
>There is at least one VFP-MySQL book available:
http://www.hentzenwerke.com/catalog/mysqlvfp.htm ( a bit dated, though )
>
>There is some information in VFP help if you type [help client server] in the Command window. In very general terms you will need to:
>
>1. Install a MySQL ODBC or ADO driver on your computer
>2. Determine the connection string or information you need to connect to MySQL from VFP. A good resource is
http://www.connectionstrings.com/mysql/ >3. Choose a method for VFP to interact with MySQL:
> - Remote Views
> - SQL Pass-Through
> - CursorAdapters (this is the only choice if you use ADO to connect to MySQL)
>
>Each of those methods can create a VFP cursor, which you use like any other VFP cursor or table. You can check in VFP help for each of those methods e.g. [help sql pass-through].
>
>You can also search for help on these topics at the Fox Wiki:
http://fox.wikis.com/wc.dll?wiki~VisualFoxProWiki
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer