The first time you run Stonefield Query, you are asked for the location of the GoldMine files and where Stonefield Query puts its files.

You can specify any directory for the Stonefield Query files, but we recommend a directory on a server; that way, you can share reports with other users.

For the location of the GoldMine files, either type the directory where GoldMine is installed or click the button beside the text box and locate the GoldMine directory in the dialog that appears.

After specifying the settings in Step 1, click the Next button.

The options in the Contact Information page are used as contact information when you send an error report to us. The options are self-explanatory. The ones with a red * are required.

The options in Step 3 are used when you want to email a report to someone or if an unexpected error occurs in Stonefield Query, in which case you have an option of emailing an error report to us so we can resolve the problem. The options are the same as in the Email page of the Options dialog.

After you've closed this dialog, it doesn't normally come up again. If you need to change any settings, see the Configuring Stonefield Query help topic. If you want to force the dialog to appear again, add an Other section to SFQuery.ini and create an Action entry under that section with a value of Setup. For example:

[Other]
Action=Setup

What happens next depends on which database engine GoldMine uses.

  • If you're using dBase as the database engine, the setup tasks are done.

  • If you're using Firebird as the database engine, Stonefield Query will then prompt you for the password to access each of the GoldMine databases you've created. These passwords are stored as encrypted values in a special location (Data.INI in the Stonefield Query reports directory) so the program won't prompt you each time you start Stonefield Query.

  • If you're using SQL Server as the database engine, Stonefield Query will then prompt you for the ODBC data source name (DSN), user name, and password to access each of the GoldMine databases you've created. Select the desired DSN from the dropdown list. Passwords are stored as encrypted values in a special location (Data.ini in the Stonefield Query reports directory) so the program won't prompt you each time you start Stonefield Query.

If you don't know the password for some of the GoldMine databases or don't wish to query on them (for example, sample databases), turn on the I do not want to query this database setting. This adds a NoPrompt=Y entry to Data.ini for those databases so you aren't asked each time you start Stonefield Query. Here's an example:

[MSSQL: GoldMine_Sample: dbo:]
NoPrompt=Y

© Stonefield Software Inc., 2023 • Updated: 11/30/21
Comment or report problem with topic