System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding?

You're gonna have to get someone who can change the code, increase the CommandTimeout (or set it to 0 for unlimited), and, more importantly, find out why the query takes so long.

Thanks Soren, but it is out of my scope to change the code. Else any hotfix for the same? – Liladhar May 7 at 10:37 any upadtes please I have updated my question – Liladhar May 10 at 8:44.

If we set the timeout value to zero that means we are making sure that the operating will competed at any cost.

You can't change the command timeout from the web. Config, though, as far as I know. (The connection timeout is unrelated.) – Sören Kuklau May 7 at 10:21 Take an example of very long operating of sql query and mention the time which is less then the time taken to complete the sql opearation.

Now on the other hand perform the same operation by setting the timeout to zero Solve the problem at run time – Pankaj May 7 at 10:27 Ok, it must missunderstanding by me,perhaps. I thought the change of timeout parameter in connection string may impact over this exception. Indeed it is out of my hand to change in code.

Any other way to identify this? – Liladhar May 7 at 10:43 Run your SQL in query analizer and see how many minutes it takes. – Pankaj May 7 at 10:44 Thanks Pankaj, perhaps I could access sql server.

It is also out of my reach – Liladhar May 7 at 11:13.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions