Cathi,

As he is going to SQL Server, the VFP OLE DB provider doesn't come into play here.


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