Search code examples
sql.net-services

Increase Sql timeout in .net

I am gettting SQL time out error in my .net service.

As the service is already installed on the production, is there any way I can increase the timeout for the service from App.Config file.

At present, I am getting this exception after one minute, I have to make it to around 10 hours because the stored procedure we are using takes 2-2 hours to execute.

Solution

  • You can set the timeout in your connection string with "connect Timeout = 100000000;" or whatever you want your timeout to be