Differences

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

--- bde_settings [2019/01/27 11:28]
127.0.0.1 external edit
+++ bde_settings [2019/07/15 15:09] (current)
bteekel
@@ Line 1: / Line 1: @@
+==== 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.
-==Explanation==
+=== 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 ===
-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.
+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
-==Adjusting the BDE==
+[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland]
-  - 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\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]
-Note: When finished remember to click the Apply arrow
+[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\\"
-==SMS 8.6 (8.90) BDE settings==
+[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Borland\Database Engine\Settings\DRIVERS\PARADOX\TABLE CREATE]
-  - Expand the Configuration
+"LEVEL"="7"
-  - Expand the Drivers
+"BLOCK SIZE"="8192"
-  - Expand the Native
+"FILL FACTOR"="90"
-  - Select Paradox
+"STRICTINTEGRTY"="TRUE"
-  - 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
-==SMS 8.91 BDE settings==
-  - Expand the Configuration
-  - Expand the Drivers
-  - Expand the Native
-  - Select Paradox
-  - Ensure the Levels is set to 7
-  - 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\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>