need help !

[TK2828]

Hi,

Can anyone help me out on this ?
from my web service I need to call a store procedure to fill a dataset which
will be returned to client. When I test my store procedure, it takes 90sec to
retrieve records ( about 30 records returned ). However, when I test the
webmethod from local IIS server by supplying the parameter and clicking the
"invoke" button, 40 seconds past, I got http 500 internal server error .

any idea ?

Thanks.

 

[Bruce Johnson [C# MVP]]

My first thought would be to turn off the friendly HTTP errors in your
browser so that more detail about the error can be viewed. Because the 500
status code is just a generic 'bad stuff happened on the server' message that
doesn't provide enough information to suggestion a solution.