Hi Guys
I have a sql stored procedure that takes 1 minute to return a set of records. When I call this stored procedure in a webservice method, this causes the webservice to time out.
Any solution on getting around this issue.
Thanks in advance for any assistance!
Regards,
Thavs
Niradhip ChakrabortyPosted Apr 30, 2009, 6:07 AM
You increased "Timeout" property of WS after consuming it. Please try that also and see what happens!
Goto: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxgrftimeoutwhiledebuggingwebservices.asp
But I am not sure it helps or not, but it's worth trying and see what happens!
or you also try this:
Right click on the website or virtual directory you webservice is running under and view the properties. Click on the ASP.NET tab and click the 'Edit Configuration...' button. Under the 'Application' tab change the value for 'Request execution timeout' value in seconds to the desired length of time - default is 110 seconds.