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.