Are you using VFP7 or a version earlier? If you are using VFP7 then I would recommend using the OLEDB provider instead of ODBC.

You can set your connection on the fly instead of setting up your connections ahead of time on each machine. You would use the SQLSTRINGCONNECT function to set it.

>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.