![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio 10.3 (C++ Win64) » Using DBISAM » Configuring and Starting the Server |
Property | Description |
EngineType | In order to start the TDBISAMEngine component as a database server, you must set this property to etServer. |
EngineSignature | Normally this property is left at the default value. However, if you do choose to change this property, you must make sure that it is set to desired value before starting the server. The default value is "DBISAM_SIG". Please see the Customizing the Engine topic for more information. |
ServerName | This property is used to identify the database server to external clients once they have connected to the database server. The default value is "DBSRVR". |
ServerDescription | This property is used in conjunction with the ServerName property to give more information about the database server to external clients once they have connected to the database server. The default value is "DBISAM Database Server". |
ServerMainAddress | This property specifies the IP address that the database server should bind to when listening for regular incoming data connections. The default value is blank (""), which specifies that the database server should bind to all available IP addresses. |
ServerMainPort | This property specifies the port that the database server should bind to when listening for regular incoming data connections. The default value is 12005. |
ServerMainThreadCacheSize | This property specifies the number of threads that the database server should actively cache for regular data connections. When a thread is terminated on the server it will be added to this thread cache until the number of threads cached reaches this property value. This allows the database server to re-use the threads from the cache instead of having to constantly create/destroy the threads as needed, which can improve the performance of the database server if there are many connections and disconnections occurring. The default value is 10. |
ServerAdminAddress | This property specifies the IP address that the database server should bind to when listening for incoming administrative connections. The default value is blank (""), which specifies that the database server should bind to all available IP addresses. |
ServerAdminPort | This property specifies the port that the database server should bind to when listening for incoming administrative connections. The default value is 12006. |
ServerAdminThreadCacheSize | This property specifies the number of threads that the database server should actively cache for administrative connections. The default value is 1. |
ServerEncryptedOnly | This property specifies whether all incoming regular data connections should be encrypted or not. If this property is set to True, then all incoming regular data connections to the database server that are not encrypted will be rejected with the error code 11277, which is defined as DBISAM_REMOTEENCRYPTREQ in the dbisamcn unit (Delphi) or dbisamcn header file (C++). The default value is False.![]() |
ServerEncryptionPassword | This property specifies the password to use for all encrypted connections. If an incoming encrypted connection does not use a password that matches this value of this property, the database server will return the error code 11308, which is defined as DBISAM_REMOTEINVREQUEST in the dbisamcn unit (Delphi) or dbisamcn header file (C++), when any call to the database server is attempted after the connection is made. The default value is "elevatesoft".![]() |
ServerConfigFileName | This property specifies the name of the configuration file that the database server will use for storing all server configuration information including users, databases, server-side procedures, user rights, and scheduled events. This file is compressed and encrypted, and a backup is made, with the extension ".scb", any time a modification is made. The default value is "dbsrvr.scf".![]() |
ServerConfigPassword | This property specifies the password to use to encrypt the contents of the server configuration file. This ensures that if someone does obtain physical access to the configuration file that they will still be unable to read its contents, especially user names and passwords, without this password. |
{ Engine()->ServerName="MyTestServer"; Engine()->ServerDescription="My Test Server"; // Only listen on this IP address Engine()->ServerMainAddress="192.168.0.1"; Engine()->ServerConfigFileName="mytest.scf"; Engine()->ServerConfigPassword="test123456"; Engine()->Active=true; }
dbsrvr.exe /install
dbsrvr.exe /uninstall
net start dbsrvr
net stop dbsrvr
Switch | Description |
/sn | Server name parameter The /sn switch specifies the user-defined server name that will be used to identify the server to remote sessions. You must enclose the server name in double quotes if there are spaces in the server name. The server name is informational only. |
/sd | Server description parameter The /sd switch specifies the user-defined server description that will be displayed in the caption of the server's user interface. You must enclose the server description in double quotes if there are spaces in the server description. The server description is informational only. |
/sa | Server address parameter The /sa switch specifies the main server IP address that the server will bind to for accepting inbound data connections. The IP address must be specified directly after the /sp switch using dot notation (i.e. 192.168.0.1). The default IP address that the server will bind to if this switch is not specified is all IP addresses available on the machine. Using this option will cause the server to only listen on the specified address. This means that it will no longer listen on the local loopback 127.0.0.1 address. |
/sp | Server port parameter The /sp switch specifies the main server port that the server will bind to for accepting inbound data connections. The port number must be specified directly after the /sp switch. The default main port that the server will bind to if this switch is not specified is 12005. |
/st | Server thread cache size parameter The /st switch specifies the main server thread cache size. The thread cache size controls how many threads the server will cache in order to speed up connect/disconnect times. The thread cache size must be specified directly after the /st switch. The default main thread cache size that the server will use if this switch is not specified is 10. |
/aa | Administration address parameter The /aa switch specifies the administration server IP address that the server will bind to for accepting administrative connections. The IP address must be specified directly after the /aa switch using dot notation (i.e. 192.168.0.1). The default administration IP address that the server will bind to if this switch is not specified is all IP addresses available on the machine. Using this option will cause the server to only listen on the specified address. This means that it will no longer listen on the local loopback 127.0.0.1 address. |
/ap | Administration port parameter The /ap switch specifies the administration server port that the server will bind to for accepting administrative connections. The port number must be specified directly after the /ap switch. The default administration port that the server will bind to if this switch is not specified is 12006. |
/at | Administration thread cache size parameter The /at switch specifies the administration server thread cache size. The thread cache size controls how many threads the server will cache in order to speed up connect/disconnect times. The thread cache size must be specified directly after the /at switch. The default administration thread cache size that the server will use if this switch is not specified is 1. |
/cf | Configuration file name parameter The /cf switch specifies the server configuration file name. The configuration file is where the server stores all configuration information including databases, users, permissions, etc. You must enclose the configuration file name in double quotes if there are spaces in the configuration file name. Do not specify a file extension for the file since the server always uses the ".scf" extension for all configuration files. The default configuration file name that the server will use if this switch is not specified is "dbsrvr". |
/cp | Configuration file password parameter The /cp switch specifies the server configuration file password. The configuration file password is used to encrypt the contents of the configuration file. You must enclose the configuration file password in double quotes if there are spaces in the configuration file password. The default configuration file password that the server will use if this switch is not specified is "elevatesoft". ![]() |
/en | Encrypted connections only parameter The /en switch specifies that the main server will require encrypted connections only. By default the administration server always requires encypted connections, but normally encrypted connections are not required for the main server. |
/ep | Encrypted connnection password parameter The /ep switch specifies the password to use for encrypting all data between any remote sessions and the main and administration server. This switch can be specified without the above /en switch to change the password for encrypted connections to the administration server only. If combined with the above switch, this switch will change the password for encrypted connections to both the main server and the administration server. You must enclose the encryption password in double quotes if there are spaces in the encryption password. The default encryption password that the server will use if this switch is not specified is "elevatesoft". ![]() |
/al | Append to log parameter The /al switch specifies that the server should append to any existing server log file when the server process is started. The default behavior is to overwrite the log every time the server process is started. |
dbsrvr.exe /sp13000 /ap13001
net start dbsrvr /sp13000 /ap13001
; Sample DBISAM Database Server Parameters INI File [Server Parameters] ; Default server name is the EXE name Server Name=Test Server ; Default server description is DBISAM Database Server ; plus the Server Name Server Description=Test Server Description ; Default server IP address is all addresses on the machine Server Address=127.0.0.1 ; Default server port is 12005 Server Port=10001 ; Default server thread cache size is 10 Server Thread Cache Size=20 ; Default admin IP address is all addresses on the machine Administration Address=127.0.0.1 ; Default admin port is 12006 Administration Port=10002 ; Default admin thread cache size is 1 Administration Thread Cache Size=4 ; Default configuration file name is dbsrvr Configuration File=Test ; Default configuration file password is elevatesoft Configuration Password=cannotguessme ; 0=main server allows unencrypted connections (default) ; 1=main server allows only encrypted Encrypted Only=0 ; Default encryption password is elevatesoft Encryption Password=cannotguessme ; 0=overwrite log file (default) 1=append to log file Append To Log=0 ; SQL performance logging ; 0=no SQL performance logging (default) 1=log all statements with execution times above the min execution time (below) SQL Performance Tracking=0 ; Minimum execution time, in seconds, required before an SQL statement is logged (default is 30 seconds) Min SQL Performance Execution Time=30 ; SQL performance log file name SQL Performance File Name= ; Max SQL performance log file size (default is 128MB) Max SQL Performance File Size=134217728 ; 0=no auto-incrementing of SQL performance log file name 1=auto-increment SQL performance log file name Auto-Increment SQL Performance File Name=0 ; Max SQL performance log file autoinc (default is 64) Max Auto-Increment SQL Performance File Name=64
dbsrvr1.exe /install net start dbsrvr1
dbsrvr2.exe /install net start dbsrvr2
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |