ConnectionTimeout
The DigaSQL.DLL has a background thread running which polls for changes and checks whether a connection is alive. If a connection is down, this thread tries to re-establish it. Therefore any foreground thread might try to execute an SQL statement, while the background thread is already executing another one. In this case the foreground thread will wait up to the time specified with this value for the first statement to finish. By default the wait time is 6000 milliseconds. Sometimes, if your network is slow or the SQL server is very busy it might happen that the background thread needs more than 6 seconds for its work. Then the error DS3580 or DS3604 will be displayed. If this happens you can increase the wait time. Another useful value is 0, which means the foreground thread will wait infinite for the background thread. This is especially (and only) useful for programs running unattended, because typically they will not retry a failed database operation. With the value set to zero, they will block until the database connection has been re-established.
One additional hint: the practical use of this value is limited as long as the background thread does not poll very often. Then it is very likely that the foreground thread will be the first to realize that the connection is interrupted. And that means it will block until its call to the server returns (which is 2 minutes typically). Only if the background thread is faster, the foreground thread can realize that something is wrong before calling the server. The polling interval of the background thread is adjusted with the value "UpdateTime" in the key "Digas\Database\Data Source Name".
Possible values:
Default value: 6000