In addition to what Kirk said, you can define a DSN-less connection in you DBC and use it in your remote views (if you will use remote views)

CREATE CONNECTION MyConn CONNSTRING "DRIVER={SQL SERVER};SERVER=xxxx;UID=yyyyy;pwd=zzzzzz;Network=DBMSSOCN;database=YouSQLDB"

>I will be designing an application which will be used by numerous
>individuals, which will need to access various SQL Server tables for
>reference lists. I have done very little work with SQL Server.
>
>Is it necessary to set up ODBC-type connections individually at each PC
>which will use this application (during application setup), or can Visual FoxPro "on-the-fly" set up temporary connections to the SQL Server tables as needed?
>
>Thanks,
>Randy W.