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:

or

To apply the changes, restart the server.

Note:

• 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).