Operating Environment for GoldMine

The Connector for GoldMine requires that GoldMine be installed and operational on the OmniRush PC.  OmniRush connects to the GoldMine database directly, via low level BDE calls, and is completely compatible with GoldMine v5.x dBase and SQL (Front Office).

 

Generally, running OmniRush and GoldMine Sync Server/Automated Processes on the same PC is workable, however it depends on the workload on these components.  It is possible to overload the BDE, which will cause all BDE applications on the PC to hang.  (Increasing the memory settings in BDE can help prevent this, but if the load is high enough, or if enough BDE applications are running, the limits of BDE may be reached.)

 

There are a number of options on how GoldMine can be configured, so here are the details.

 

Requirements for GM v7 and Up:

 

- GoldMine v7/8 must be installed locally, on the OmniRush server PC as a GoldMine workstation.

Do not install OmniRush until GoldMine runs properly on the OmniRush PC.

- During initial OmniRush installation, when asked by the wizard, select the network location of GM
- After installation, configure the database connector to point at the local installation of GoldMine

 

Environment Item

Discussion

GoldMine installed locally on OmniRush PC, or centrally on a network.

For GoldMine v6 and earlier: OmniRush will work both ways.  Install GoldMine as you prefer, just make it sure that the NT user you choose during OmniRush installation can access the GoldMine file system resources (SYSDIR in all cases, other directories vary based on overall configuration).

Z-Firm recommends a shared, network installation of GoldMine for easiest maintenance and to keep the build consistent across the network.

For GoldMine v7/8 and up: GoldMine must be installed locally on the OmniRush server PC.

BDE, shared or local (applies to GoldMine v6.x and earlier)

Z-Firm requires that BDE be installed locally on the OmniRush Server PC.  Check the registry

 

HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\

 

setting to confirm that BDE is being pulled from a local path (see the DLLPATH and CONFIGFILE01 keys).

BDE Settings (applies to GoldMine v6.x and earlier)

In many cases it is advisable to increase BDE memory settings.  See the technical discussion for details.

GM.INI file

Check that all values are correct.  In many cases GoldMine will run even if the GM.INI has invalid settings in it.  Z-Firm recommends that the GM.INI have at least the following tags:

SYSDIR, GOLDDIR, COMMONDIR.  Click here to see an example GM.INI file.

SQL Specific

Check that the database owner is dbo.  For a detailed list of SQL environment issues, see the GoldMine SQL technical discussion.