Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding.

Connect timeout=18000;

    <add name="constr" connectionstring="Data source=127.0.0.1;initial CATALOG=HXMRP_PRD; User Id=sa; Password=sa_sa; Max Pool size=150; Connect timeout=18000; " />

Also some say is Connect timeout=500;

But it does not seem to solve my problem, the same 30 seconds after continuing to error .....

After the CSDN blog, find a Solution: http://blog.csdn.net/ulark/article/details/5208779 (original)

The commandtimeout code for setting SqlCommand is as follows:

SqlCommand cmd = new SqlCommand (); cmd.commandtimeout = 180;

Run again, that is, fix it, set the time here for 180 seconds, that is, three minutes! You can set it yourself as needed.

Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding.