Connection times out

[stephenk1973]

I'm running a stored procedure on my SQL Server, it takes a minute or two depending on the passed parameters.

When i attach my .Net page the page always times out after 30seconds, but in may sting i (think) i have set the timeout to 200s. web.config as below....

Where should i be setting the Timeout?

Thanks

Stephen


<connectionStrings>

<add name="AAReportConnectionString" connectionString="Data Source=AAPPS02;Initial Catalog=AAReport;Integrated Security=True;Connection Timeout=200;" providerName="System.Data.SqlClient"/>

</connectionStrings>


w

 

[ca8msm]

When i attach my .Net page the page always times out after 30seconds

In that case, it's the page that is timing out not the connection to the database. Try setting this timeout:

http://www.devx.com/vb2themax/Tip/18803

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[stephenk1973]

i added the following to me web.config, weather the value is 2 or 2000 the page still times out after 30 seconds.

<httpRuntime executionTimeout="200"/>


The page in in a master page, could this confuse it?

Thanks

Stephen

 

[ca8msm]

No, it's irrelevant of whether it is a Master page or not. If the above didn't work, you may want to try setting the Server.ScriptTimeout in the page. If that doesn't work, you'll have to look at the timeout that is set for scripts in your web server (e.g. IIS).


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.