By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,078 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,078 IT Pros & Developers. It's quick & easy.

soap timeout on big report

P: n/a
Hi, my web application connects to a web service. The web service runs
a long running sql server stored procedure. The stored procedure takes
4 minutes. I get timeouts. In my web service connection string it has
"connect timeout = 300" This is 5 minutes to wait for a connection
handshake right?

In my web method I have the sqlcommand time out at 3000 -- 50 MINUTES!!
LOL

sqlCom.CommandTimeout = 3000;

But still it times out at between 1 and 3 minutes. ? Curious ??

Why oh why does it time out??

If I run the stored procedure from Microsoft SQL Server 2000 Query
Analyzer it will run OK after 4 minutes.

Anto

Nov 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
the webservice page and the calling page have a timeout also.

-- bruce (sqlwork.com)
"Antonio" <bl*****@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
Hi, my web application connects to a web service. The web service runs
a long running sql server stored procedure. The stored procedure takes
4 minutes. I get timeouts. In my web service connection string it has
"connect timeout = 300" This is 5 minutes to wait for a connection
handshake right?

In my web method I have the sqlcommand time out at 3000 -- 50 MINUTES!!
LOL

sqlCom.CommandTimeout = 3000;

But still it times out at between 1 and 3 minutes. ? Curious ??

Why oh why does it time out??

If I run the stored procedure from Microsoft SQL Server 2000 Query
Analyzer it will run OK after 4 minutes.

Anto

Nov 19 '05 #2

P: n/a
please show me how to code it

Nov 19 '05 #3

P: n/a
I GOT IT

MyWebService.Timeout = System.Threading.Timeout.Infinite;
THANKS!!!!!

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.