Setting up the SQL server response timeout
To set up the SQL server response timeout (timing settings), add the command commandTimeOut=" " to the configuration file. This command sets the timeout before stopping attempts to execute a command and returning an error. In the quotation marks specify the timeout in seconds (by default, 30 seconds).
The configuration file (configuration.config) is located in ELMA Directory\UserConfig. Open it with a text editor. Insert commandTimeOut=" " at the end of this line:
and specify the timeout in seconds. The string may also look like this:
After setting up (let's set a 150 seconds timeout as an example), the string will look like this:
To apply the changes, restart the server.
- If you set 0, the SQL server timeout will be unlimited.
- commandTimeOut does not have any effect if a command is executed with a context connection (SqlConnection is opened with "context connection=true" in the connection string).