Timeout expired. Hate

[level1]

I have a page that connects to SQL server 2000 and executes a very large query, that returns a small amount of records. The query takes about 2 minutes to execute in query analyser but the ASP.NET page expires before i get any results on screen.

The full message i get is:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I have full control on the server and i also use all the followings but non of them seems to do the trick.

Me.sqlcn.ConnectionString = "packet size=4096;user id=*****;password=*****;data source=*****;persist security info=False;initial catalog=*****;connection timeout=3600;"


Me.SqlSelectCommand1.CommandTimeout = 3600


Page.Server.ScriptTimeout = 3600

Also on the local web.config i use

<httpRuntime executionTimeout="3600" />


my page still expires after 30 secs....
and finally i set the IIS to connection timeout = 3600

Does anybody know how to extend the timeout period for running complex queries to as many minutes as i like.
PLEASE HELP

 

[checkai]

have you fully looked at your query to make sure it's at it's most optimized speed? that would be my first step...

 

[IBACFII]

From What I remember If you set the time out to "0" the number, ie connection timeout=0 ,then it will run until it is done.

Hope that helps maybe it will.
Let me know.

IBACFII