Stonefield Query normally uses a connection string to connect to an ODBC data source, even if you specify a data source name (DSN) in the
Select Data Source dialog. Using a connection string has the advantage that the DSN doesn't have to exist on the user's system. Also, connection information can easily be changed dynamically in a
GetDataSources script for a database.
However, there are a couple of instances where using a connection string rather than a DSN isn't a good idea:
- If your Stonefield Query project is used with a commercial application that uses DSNs. In that case, you'll likely set the User Can Manage Data Sources setting to True. Doing so changes the Use DSNless Connection setting to False automatically and you cannot edit its value.
- Some database engines, such as Btrieve, Pervasive (the new name for Btrieve), and Adaptive Server Anywhere, do not support connection strings. In that case, a DSN must be specified instead.
See Also
Configuration Settings | GetDataSources