Hi,
I am working on an application, where am collecting all the inputs from the user in web form, based on the inputs, form a query to the database (running on different server) and show the output as response.
The problem is , database query is taking a lot of time ( approx 2min).
By that time , the request times out and nothing is displaed as output.
How to set the timeout for request ?
Thanks,
Vijay

Hi,
Try setting timeout property in Web.config if you are using sessionState.
<sessionState mode="StateServer" stateConnectionString="tcpip=127.0.0.1:55455" sqlConnectionString="data source=127.0.0.1;user id=sa;password='' cookieless="false" timeout="200"/>


Regards,
Chandrak

Hi Bhavsac , U have mentioned about session time out .That is different from connection out.

VijayT , U can use connection.timeout property to solve this problem.
connection.timeout=300

DO this after opening connection

Hi Rama,
Thanks for your reply.
Unfortunately, I tried that but it did not solve the problem.
I found out that the problem was because I was using Atlas components (updtaePanel ) as a container.That precisely times out in 90 sec.
Thoug I could find the origin of the problem, I am still clueless how to resolve it.I tried various things with "UpdatePanel" setting, but nothing works.

there is another option it is: CommandTimeout
it means how long single SQL comand can take to run.

--CommandTimeout how long single SQL command can take to run
System.Data.SqlClient.SqlCommand cmd;
cmd.CommandTimeout = 200;

--ConnectionTimeout How long may take to open connection
System.Data.SqlClient.SqlConnection con;
con.ConnectionTimeout = 200;

tadas @ mohawkideas.com

Hi ,
Yes, i tried Coomand timeout, but it did not work for me.
Actually, another dimension to the problem is - I am using "Atlas" (AJAX for Asp .Net 2.0).Is that something to do ith "Atlas" ? If yes, how can I set the timeout for it ?
Thanks,
Vijay