473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

soap timeout on big report

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
3 1390
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
please show me how to code it

Nov 19 '05 #3
I GOT IT

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

Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Blaine Everingham | last post by:
Hello, I have installed SOAP::Lite 0.60 and am running a simple test to see the XML output. I noticed that the output indicated it's using the www.w3.org/1999/XMLSchema instead of the prefered...
0
by: Kyle K | last post by:
I am getting occasional errors when invoking calls on the low level API of the SOAP library (3.0 Toolkit). The HRESULT code is always 0x800A1518. The _com_error Description is "Connector:Http...
1
by: Clara Yeung | last post by:
I have captured some SOAP messages (using org.wsi.test.monitor.Monitor of the WSI test tool). When I try to analyze the messages with WSI test tool analyzer, the "message" artifact of the report...
2
by: Jose Maestro | last post by:
I am using MS SOAP client provided with SOAP Toolkit 3.0. I have set the timeout for this application to 20 seconds. On some occasions, when there are network problems and the call to the...
16
by: MR | last post by:
my soap messages to a remote site are failing. as far as i can tell the only differences between what my SOAP message looks liek and what they want are in the SOAP envelope SInce they don't have a...
0
by: Sabicho | last post by:
Hi. I've installed the latest version of SugarCRM (the open source version) and i'm trying to generate a xml file with all the contacts, by using the SugarCRM soap api. I'm using the...
1
by: lkosak | last post by:
Hi everyone, I am encountering what appears to be a timeout problem using a PHP soap client to connect to a VB.net soap server. I cannot provide the WSDL as it is only available for internal...
0
by: cbeels | last post by:
The client code is #install SOAP-Lite and MIME-tools packages use SOAP::Lite 'trace', 'debug'; #override version SOAP::Lite->soapversion('1.2'); #override credentials sub...
1
Plater
by: Plater | last post by:
I have a webservice that claims the following: SOAP 1.1 The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values. POST...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.