>Is there any articles on building application using VFP as the frontend tool and SQL Server and the backend or any other articles related to setting up the database connection using VFP? Thanks in Advance.

Take a look at www.hentzenwerke.com
There's a book that's exactly what you're asking for. :)