You can also use OLE DB.
>Yes, you can.
>There is two different ways (at least for VFP7):
>You can get and set the information from SQL DB via Remote Views or with SQL Pass-Through. Take a look in ALL functions that begins with SQL...(). All you need is an ODBC connection to SQL Server or a connection stored in your DBC.
>If you update VFP to 8 or 9 you will have an additional way (the way i love) - CursorAdapters. Then connection can be ODBC or ADO.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer