Setting the User Can Manage Data Sources configuration setting to True has two effects on Stonefield Query. First, the Setup dialog that appears the first time the user runs Stonefield Query has two pages of information, the second page of which is a list of DSNs on the user's system. The user can select which DSNs are used with Stonefield Query and enter the data source user name and password. The second effect is that a Manage Databases function appears in the Tools menu. Choosing this item displays a dialog similar to the second page of the Setup dialog, allowing the user to choose which DSNs Stonefield Query can work with.

In both cases, a Test button allows the user to test the connection to the specified database. It does this by trying to connect to the database and then perform a small query against the table specified in the Table to Test setting. If this setting is blank, Stonefield Query uses the first table in alphabetical order. Many times, this is sufficient. However, there may be times when you want to use a different table instead.

See also

Configuration Settings | User Can Manage Data Sources