Timeout expired error

  • Thread starter Thread starter meena_alag
  • Start date Start date
M

meena_alag

Hi,

How do I avoid the following error:

"Timout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding"

My sql query takes 1 min to fetch 1 lakh records. I have set the
CommandTimeOut in C# to 3 mins and still i am getting the above
error.

Please suggest a solution to this issue asap.

Thanks in advance,
Meena
 
It could be the connection timeout that's giving you the problem- but it's a
readonly property unless you set it in the connection string.
 
Back
Top