The operation has timedout Error!!!(URGENT)

[goal2007]

I was getting SQLException Time out so i added this line cmd.CommandTime out = 1000;
also in my ScriptManager i set AsyncPostBackTi meout="1200". now when i run my application all what i get is this
The operation has timedout. no further explanation from where it is hapning.
Any Thoughts!

Thanks

[Plater]

You do not have very much in the line of useful details there.

What is actually the time out? The connecting to the database? the sql query? manipulating the data in the code?

I take it this is a web application? If your page takes too long to load, the client will close the connection because it thinks you're never coming back with anything.

[goal2007]

You do not have very much in the line of useful details there.

What is actually the time out? The connecting to the database? the sql query? manipulating the data in the code?

I take it this is a web application? If your page takes too long to load, the client will close the connection because it thinks you're never coming back with anything.

Thank you for your replay.

Basically I ued to get SQL time out exception which I did fix it by changing the timeout prosperity. Then I got another timeout exception from my script manager which all what I need to do is change the AsyncPostBackTi meout to a bigger number. Now when I run my application all what I get is “The operation has timed out” This is all what I am getting and I am not sure what is going on. I am pretty sure it is not my sql or my script manager. Can you tell me what I should do because I am lost at this point

Note: the page will take too long to load becuase i am downloading a file via a stored procedure. Also i only get this error if the file is too big. if the file is small everything work fine

thanks

[Plater]

You will need to change the connectiontimeo ut in the header of your webpages.
So that the client "waits longer" for data to arrive.

Also consider ways to speed up your queries. Use folding with inner joins and such. The SQL section of the form could probably be more helpful then I can on that.

[goal2007]

You will need to change the connectiontimeo ut in the header of your webpages.
So that the client "waits longer" for data to arrive.

Also consider ways to speed up your queries. Use folding with inner joins and such. The SQL section of the form could probably be more helpful then I can on that.

how do i change the connection timeout in the header of my webpages? can you give me an example?

I just tryied this but still did not work

<%@ Page Language="C#" AutoEventWireup ="true" MasterPageFile= "~/MasterPage.mast er" CodeFile="Test. aspx.cs" AsyncTimeout="3 6000" Inherits="Test" ValidateRequest ="false"%>

Thanks

[goal2007]

how do i change the connection timeout in the header of my webpages? can you give me an example?

I just tryied this but still did not work

<%@ Page Language="C#" AutoEventWireup ="true" MasterPageFile= "~/MasterPage.mast er" CodeFile="Test. aspx.cs" AsyncTimeout="3 6000" Inherits="Test" ValidateRequest ="false"%>

Thanks

I got it all what i needed to do is adding this line:

in my page load that uses my web service i put this line of code:

WebServiceName. Timeout = System.Threadin g.Timeout.Infin ite;