Thanks Craig for pointing this out. I read right over that. It must be Monday!

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