How to set Timeout in a Connection String

In this article, we are going to review the process of how to set up command timeouts in a data source connection string.

For most databases that you can connect to Wyn there is a standard timeout setting of 30 seconds.

In Wyn if you use the connection string option when creating a datasource you can then change this default timeout to fit your needs.

The keyword for most databases such as SQLServer is CommandTimeout=xxx, where xxx is the seconds you want to set the timeout, but others use ConnectionTimeout, etc.

So in this image I have set my connection to time out after 6,000 seconds, which is 100 minutes.