BDE Settings


Explanation

The Borland Database Engine (BDE) settings are automatically configured during the installation and/or update of Cyrious SMS. At times though, other programs or staff may have modified the settings to address a specific problem. As a reference, below are the settings that provide the most stable BDE environment.

Adjusting the Configuration from the BDEAdmin

  1. On the Server for Cyrious, navigate to the BDE folder.
    1. By default, it is located in C:\Program Files (x86)\Cyrious\Common\BDE\
  2. Double click the bdeadmin.exe
  3. Click the Configuration tab.
  4. Expand Configuration > Drivers > Native and click Paradox.
    1. Note: If the Paradox driver is not present, the settings can and should be altered through the Registry editor instead. Do not delete any registry keys as a solution to enable the Paradox drive in the bdeadmin.

BDE settings

  1. Expand the Configuration
  2. Expand the Drivers
  3. Expand the Native
  4. Select Paradox
    1. Set BLOCK SIZE = 8192
    2. Set LEVEL = 7
  5. Expand the System
  6. Select the INIT
    1. Set AUTO ODBC = FALSE
    2. Set MAXBUFSIZE = 8192
    3. Set MAXFILEHANDLES = 96
    4. Set MEMSIZE = 32
    5. Set MINBUFSIZE = 256
  7. Click the Apply arrow

Borland Registry Key

It is also good practice to verify the settings in the registry for the BDE to ensure everything is set properly. Below is an export of the Borland HKEY_Local_Machine registry key for reference. 

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland]

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine]
"DLLPATH"="C:\\Program Files (x86)\\Cyrious\\Common\\BDE\\"
"CONFIGFILE01"="C:\\Program Files (x86)\\Cyrious\\Common\\BDE\\idapi32.cfg"

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings]

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS]

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS\PARADOX]

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS\PARADOX\INIT]
"VERSION"="4.0"
"TYPE"="FILE"
"LANGDRIVER"="DBWINUS0"
"NET DIR"="C:\\Program Files (x86)\\Cyrious\\Common\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS\PARADOX\TABLE CREATE]
"LEVEL"="7"
"BLOCK SIZE"="8192"
"FILL FACTOR"="90"
"STRICTINTEGRTY"="TRUE"

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\SYSTEM]

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\SYSTEM\INIT]
"VERSION"="4.0"
"LOCAL SHARE"="TRUE"
"MINBUFSIZE"="256"
"MAXBUFSIZE"="8192"
"LANGDRIVER"="DBWINUS0"
"MAXFILEHANDLES"="96"
"SYSFLAGS"="0"
"LOW MEMORY USAGE LIMIT"="32"
"AUTO ODBC"="FALSE"
"DEFAULT DRIVER"="PARADOX"
"MEMSIZE"="32"
"SHAREDMEMSIZE"="8192"
"SHAREDMEMLOCATION"=""
"DATA REPOSITORY"=""
"SQLQRYMODE"=""
"MTS POOLING"="FALSE"