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 Step 2 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:

• I use Outlook or a similar program for email (MAPI): choose this option if you use a MAPI-based email client such as Outlook. If you don't use Outlook and you're not sure if your email client uses MAPI or not, ask your system administrator.

• I use Outlook Express or a similar program for email (SMTP): choose this option if you use an SMTP-based email client such as Outlook Express. If you don't use Outlook Express and you're not sure if your email client uses SMTP or not, ask your system administrator.

• Your name: your email descriptive name (SMTP only)

• Your email address: the email address to use as the "reply to" address (SMTP only).

• Mail server address: the address for your SMTP mail server. If this isn't filled in by default, check your email client to see how it's set up. For example, if you use Outlook Express, choose the Accounts function from the Tools menu, select the appropriate account and click Properties, then look at the Outgoing mail (SMTP) option on the Servers page for the address of the mail server.

• My email server requires authentication for outgoing messages: turn this option on if applicable. To determine if you should turn this on or not, check your email client setup. For example, if you use Outlook Express, choose the Accounts function from the Tools menu, select the appropriate account and click Properties, then look at the My server requires authentication option on the Servers page.

• User name: the user name to use if the My email server requires authentication for outgoing messages option is turned on.

• Password: the password to use if the My email server requires authentication for outgoing messages option is turned on.

• Test: once the email options are set, click this button to send a test message to yourself. This allows you to ensure the email settings are correct.
  

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

  [C:\Program Files\GoldMine\Data\GOLDMINE.FDB]
  NoPrompt=Y

• 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