Timeout expired Problem ???? [modified]

[devboycpp]

In my ASP.NET.net site ,I sometimes(but not always) get this error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I think its sql server error . Someone tell me how I can solve this problem. I need urgent help . -- modified at 7:39 Friday 20th October, 2006

Best regards Hossein Yahoo ID :hosseinnick

[Gerald Leslie Jones]

Are you getting time out while executing the database query? If so, you need to set the SQLCommand.CommandTimeout property. If not, You can change timeout="infinite" in processmodel node of the machine.config. Hope this helps. Get back if not. Cheers,

Gerald Leslie Jones

[ednrgc]

You may want to check out the Stored Procedure / View / SQL Query you are calling. These errors usually occur during long processes on the database server. Run a profiler to see where the bottlenecks are in your process.