Increase Sql timeout in .net

Question

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.

Answer 1

You could try setting the CommandTimeout property on your SqlCommand. I hope you are not doing this in an ASP.NET application.

Answer 2

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