Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bde_settings [2019/06/14 16:18]
vsouvannarath 		bde_settings [2019/07/15 15:09]
bteekel
Line 1: Line 1:
 +==== BDE Settings ====
  
-===== DBE 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 ===
  
-==Explanation==+  - 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
  
-Generally, the BDE settings should be correct based on the version of SMS installed. However, there are occasions where they can use some tweaking. Below are the settings that seem to work help when there seems to be some issues with SMS accessing the data or constant corruption.+=== 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>
  
-==Adjusting the BDE== +Windows Registry Editor Version 5.00
-  - Access the Cyrious server +
-  - Navigate to Cyrious>Common>BDE +
-  - Double click the bdeadmin.exe +
-  - Select the Configuration tab +
-  - If theParadox level is not there: +
-    - Open the Registry +
-    - Navigate to HKey Local Machine>Software>Wow6432Node>Borland>Database Engine>Settings +
-    - Delete the Settings key - this should allow you to access Paradox drivers+
  
 +[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"
  
-Note: When finished remember to click the Apply arrow+[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]
  
-==SMS 8.6 (8.90) BDE settings== +[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS\PARADOX\INIT] 
-  - Expand the Configuration +"VERSION"="4.0" 
-  - Expand the Drivers +"TYPE"="FILE" 
-  - Expand the Native +"LANGDRIVER"="DBWINUS0" 
-  - Select Paradox +"NET DIR"="C:\\Program Files (x86)\\Cyrious\\Common\\"
-  - Ensure the Levels is set to 5 +
-  - Expand the System +
-  - Select the INIT +
-  - Set the AUTO ODBC to True +
-  - Set MAXBUFSIZE to 5120 +
-  - Set MAXFILEHANDLES to 5120 +
-  - Set MEMSIZE to 5120 +
-  - Set MINBUFSIZE to 5120 +
-  - Click the Apply arrow+
  
 +[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]
  
-==SMS 8.91 BDE settings== +[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\SYSTEM\INIT] 
-  - Expand the Configuration +"VERSION"="4.0" 
-  - Expand the Drivers +"LOCAL SHARE"="TRUE" 
-  - Expand the Native +"MINBUFSIZE"="256" 
-  - Select Paradox +"MAXBUFSIZE"="8192" 
-  - Ensure the Levels is set to 7 +"LANGDRIVER"="DBWINUS0" 
-  - Expand the System +"MAXFILEHANDLES"="96" 
-  - Select the INIT +"SYSFLAGS"="0" 
-  - Set the AUTO ODBC to True +"LOW MEMORY USAGE LIMIT"="32" 
-  - Set MAXBUFSIZE to 5120 +"AUTO ODBC"="FALSE" 
-  - Set MAXFILEHANDLES to 5120 +"DEFAULT DRIVER"="PARADOX" 
-  - Set MEMSIZE to 5120 +"MEMSIZE"="32" 
-  - Set MINBUFSIZE to 5120 +"SHAREDMEMSIZE"="8192" 
-  - Click the Apply arrow +"SHAREDMEMLOCATION"="" 
- +"DATA REPOSITORY"="" 
 +"SQLQRYMODE"="" 
 +"MTS POOLING"="FALSE" 
 +</code>