sql server connect: In this post I am going to try to simply a question that I posted earlier.

Can I use VFP to access a SQL Database? If so what is the command?

What is the best software for creating applications to work with SQL?

I am just getting my feet wet with SQL so please take it easy on a rookie.

You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.

--
Andrew J. Kelly SQL MVP


[quoted text, click to view]