Here’s the situation…
This is related to timeouts on calls to stored procedures in the database.
The timeout value set in the web.config file was 300 seconds as follows:
<add name="XXX" connectionString="Server=eve.wctnet.org;Database=XXXP_Prog;Uid=xxx_user;Pwd=xxxxxxConnect Timeout=300" providerName="System.Data.SqlClient"
When executing a form/page with a call to GetIntPerAndSpouse, the page/form would timeout after about 20 seconds.
So, we added code to the code-behind for one InfoPath form as follows:
Cmd.CommandTimeout = 300;
And, then the procedure completed normally – in about 40 seconds.
So, obviously, the timeout set in the web.config file was not having any effect.
So the question we have is
What could be causing the web.config file setting to be ignored
Is there a setting the we may not have set? Since this application has a considerable number of form, using the CMD.COMMANDTIMEOUT in all of them seem like a lot of
work if we could get the web.config file to do it for us.
View Complete Post