Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ==== 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 === - On the Server for Cyrious, navigate to the BDE folder. - By default, it is located in C:\Program Files (x86)\Cyrious\Common\BDE\ - Double click the bdeadmin.exe - Click the Configuration tab. - Expand Configuration > Drivers > Native and click Paradox. - 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 === - Expand the Configuration - Expand the Drivers - Expand the Native - Select Paradox - Set BLOCK SIZE = 8192 - Set LEVEL = 7 - Expand the System - Select the INIT - Set AUTO ODBC = FALSE - Set MAXBUFSIZE = 8192 - Set MAXFILEHANDLES = 96 - Set MEMSIZE = 32 - Set MINBUFSIZE = 256 - 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. <code> 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" </code>