Hi Ray,

>Please what is the best way to connect SQL server to Visual Foxpro. The client that I am working for now is insisting on using SQL server as the backend database.
>I want to use FOXPRO as the front end and SQL server as the backend.
>please I need help urgently.

Create ODBC conection with the DB.
See, in VFP Help, the functions:
- SqlConnect()
- SQLExec()
- SQLDisconnect()
And others SQL... functions.
Good Luck!