Click here to Skip to main content
15,885,757 members
Please Sign up or sign in to vote.
1.22/5 (2 votes)
See more:
Dear sir,
i have problem when implimenting project in asp.net.The problem is when i upload my project on server and start execution the page not work, some time work then later stop execution.May be this happend due to check validation large in project and many time connect with database but i always open and close database properly and also i am writing connection string what required for long time live execution.


HTML
add name="ConnectionString2" connectionstring="Driver={MySQL ODBC 5.1 Driver};uid=[user id];pwd=[*****];port=3306;database=databasename;Connect Timeout=72000; pooling='true'; Max Pool Size=72000" providername="System.Data.Odbc" 



The page not give me error and also not completed task.Actually i am trying to insert data near about 5000 and check validation at aleast three times then later insert each row on database and Finally those data show on grid view by grid view databound method.
so please give me solution as soon as possible.


The problem is why my page execution not completed.He is not lived upto my all record save in database.
Posted
Updated 22-Jul-14 18:23pm
v5
Comments
ZurdoDev 22-Jul-14 9:58am    
Solution to what?

1 solution

1-page execution timeout only applies if debug=false.
<compilation debug="false" targetFramework="4.0" />
Set debug="false" should solve the problem.
2-You can set below value in web.config for  specific page.
For example, to change the timeout for one specific page:

<location path="somefile.aspx">
	<system.web>
		<httpRuntime executionTimeout="180"/>
	</system.web>
</location>

3-Add command.CommandTimeout = 30000;

4-try to setting the shutdownTimeout value in the httpRuntime section, The default shutdown time of an idle application is 90 seconds.
<httpRuntime maxRequestLength="2147483647" shutdownTimeout="360" executionTimeout="3600"/>
 
Share this answer
 
v3
Comments
Member 8089110 23-Jul-14 9:02am    
Not working Sir..i am improving your code in my project but not work.Thanks to suggestion.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900