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 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:
Use MAPI to send emails: choose this option if you use a MAPI-based email client such as Microsoft Outlook. If you don't use Outlook and you're not sure if your email client uses MAPI or not, ask your system administrator. Note that Stonefield Query requires the 32-bit version of Outlook and cannot send emails if you installed the 64-bit version. If that's the case, use SMTP instead. Also, MAPI isn't recommended if you want to email a scheduled report as it often fails. The other options on this page don't apply if you choose MAPI.
Use SMTP to send emails: choose this option if you use an SMTP-based email system or can configure your email system to use SMTP. Note that if you use Microsoft Exchange, it must be configured by your administrator to work with SMTP. This is the preferred option for emailing because it's more reliable.
Your name: your email descriptive name.
Your email address: the email address to use as the "reply to" address.
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 Gmail, use "smtp.gmail.com:587".
SMTP port: the port for your SMTP mail server. This defaults to 25, but can be changed if necessary. As with Mail server address, check your email program's account settings and use the same port number here. For Gmail, use 465.
Use SSL/TLS: turn this setting on if your email server uses SSL/TLS. Turn this on for Gmail.
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.
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:
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., 2018 • Updated: 05/22/18
Comment or report problem with topic