logo

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:

<main connectionStringName="MainDB" type="EleWise.ELMA.Extensions.MSSQL.MSSQLProvider, EleWise.ELMA.Extensions.MSSQL" backupenabled="false">,

and specify the timeout in seconds. The string may also look like this:

<main connectionStringName="MainDB" type="EleWise.ELMA.Extensions.MSSQL.MSSQLProvider, EleWise.ELMA.Extensions.MSSQL" backuppath="">.

After setting up (let's set a 150 seconds timeout as an example), the string will look like this:

<main connectionStringName="MainDB" type="EleWise.ELMA.Extensions.MSSQL.MSSQLProvider, EleWise.ELMA.Extensions.MSSQL" backupenabled="false" commandTimeOut="150">

or

<main connectionStringName="MainDB" type="EleWise.ELMA.Extensions.MSSQL.MSSQLProvider, EleWise.ELMA.Extensions.MSSQL" backuppath="" commandTimeOut="150">.

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