i have this error
The request channel timed out while waiting for a reply after 00:00:58.9599405. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.

this is the code
ServiceReference1.ReviewsSoapClient sc = new ServiceReference1.ReviewsSoapClient();
DataSet result = sc.GetSPData(1);

Please answer:
Can you post your web service code?
What VS/SQL server version are you using?
Note: I do not expect a timeout for such a tiny amount of data. How long does the query execute/ web service method?

0

enrique_aeoAuthor Commented: 2011-10-29

I attached the code of a web service
SQL server version is R2
the method returns a single recordReviewsWebService.txt

0

enrique_aeoAuthor Commented: 2011-10-29

I returned to the test and it worked, it is likely that the sql server service has been stopped. thanks