BDE DiscussionBDE DiscussionThe Borland Database Engine is used by the OmniRush database connectors to GoldMine and SalesLogix. This discussion applies to all applications that use BDE, including:
CRM Products: GoldMine v4.x, 5.x and 6.x; SalesLogix v3.x, v4.x, v5.x
Z-Firm Products: OmniRush (when used with any of the applications listed above)
Additional
BDE resource: The Z-Firm Knowledge Base at www.zfirm.com.
** Warning**: This document contains resolution steps
that involve system modifications to the registry. It
is possible to completely disable your PC when working with the Registry.
Steps below
should be performed ONLY after a full backup has been made, and only by
a qualified PC technician.
In many cases, the BDE memory should be increased, especially if multiple database connectors are in use concurrently, or if the CRM application will be run on the OmniRush PC.
Avoid
spaces in BDE Alias names.
Unable to initialize the Borland Database Engine Error....." (example: error: $210D, $2A06, $2501, $2104)
error on launch: "FaxRush could not detect the Borland Database Engine on this system.
GoldMine will not launch and tenders error: Goldmine cannot dynamically load functions from IDAPI32.DLL. Please re-install the Borland Database Engine (BDE) BDE Error: 8461
Test One:
Launch BDE Admin. This is done by either selecting BDE Administrator in the control panel, or, if you do not have an icon for BDE Admin in control panel, see the steps at the end of this document to launch BDE manually.
If you have the "classic" BDE problem, there will be an error at this point. The error will be to the effect: 8712 : $2208 : Could not find object.
If this is the case, reinstall BDE.
Test Two:
Launch BDE Admin
Launch the BDE based CRM application (GoldMine or SalesLogix)
The symptom is either an error or that one of the two applications does not launch at all (though it may show up on the Windows Process list in Task Manager). If this is the symptom, the steps are to adjust the SHAREDMEMLOCATION and if the problem persists to also increase BDE Memory.
The BDE settings from BDE Administrator (shown below) can be modified as follows:
LOW MEMORY USAGE LIMIT increase to 128, 256, or 512
MAXBUFSIZE can be set to 4096 or 8192 (in kb, no upper limit)
MAXFILEHANDLES should be set to 196 or 256
MEMSIZE can be increased to 24, 36, or 48 as needed (use smaller values first)
SHAREDMEMSIZE can be set to 4096 or 6144 (in kb, no upper limit)
Whenever any setting is changed, BDE Admin and all other BDE applications must be closed (or the system restarted) for the change to take effect. Then, be sure to test running the CRM application and BDE Admin at the same time to check for proper operation of BDE. In many cases, SHAREDMEMLOCATION must be adjusted after making the changes noted above.
Extreme BDE
MAXBUFSIZE can be set to 32768 or any multiple of 4096.
MEMSIZE max setting: 205 (in mb, should not be more than %30 of system RAM)
SHAREDMEMSIZE in kb, can go up to 32768 or 65536
In many cases, the SHAREDMEMLOCATION setting needs to be either set or changed (in most cases, by default it will have no setting).
The initial values to try are:
NT/2000/XP, set to: 7000
Win9x set to: E000
Alternate values for SharedMemoryLocation if the above setting does not help:
NT: 6000, 5000
Win9x: E500, 8000
Other alternate values for Win95/98: 9000, A000, B000, C000, D000, E000, F000
If none of these work, try the x500, e.g.: 9500, A500, B500, etc.
In all cases, after making a change to this setting:
Exit the BDE administrator
Exit all BDE-based applications (including shutting down all OmniRush modules and Administrator)
Restart the applications.
Note
that changing the SHAREDMEMLOCATION may require also changing the SHAREDMEMSIZE
(typically to make SHAREDMEMSIZE smaller)
Generally, you should have an icon in Control Panel called BDE Administrator that launches BDEADMIN. However, if you do not, or if this BDEADMIN does not run, you can manually launch BDEADMIN by locating BDEADMIN.EXE.
There are a few ways to determine where BDEADMIN.EXE can be found:
a) In GoldMine, go to Help | About | System. One of the settings displayed is the directory of the BDE DLLS. BDEADMIN.EXE will be in the same directory.
b) On a network, go to \<gmdir>\setup\bdeshare\ and you will find BDEADMIN.EXE here.
c) On a standalone PC, go to c:\program files\borland\common\bde\ and you will find BDEADMIN.EXE here.
Find the BDE registry key using REGEDIT:
HKEY_LOCAL_MACHINE\SOFTWARE\BORLAND\DATABASE ENGINE
Rename the DATABASE ENGINE to a new name, e.g. OLD-DATABASE ENGINE
Reinstall BDE using either the stand alone BDE installer from a SalesLogix CDROM or using the GoldMine Installshield installer and selecting BDE only.