Operating Environment for GoldMineThe 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. |