Question on SQL Server connections

[RRW]

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.

 

[wgcs]

You can either create a DSN (odbc connection name) programmatically, or use DSN-Less connections (the second being my preference).

Create a DSN programmatically: faq184-1538
Use DSN-Less connections:

http://fox.wikis.com/wc.dll?Wiki~DSNLessConnections