Webserver which is hosting multiple sites on IIS 6.0 gets stuck after a few hours. Webserver Responds but DB does not

Question

IIS6.0 frame work 2.0

sql server 2005

My webserver which is hosting multiple sites on IIS 6.0 gets stuck after few hours..the response comes from the webserver but the DB is not responding..it again comes up only when we recycle the Application pool for the sites from IIS...we have latest configuration on the server and we cant restart the server as it will clear all our sessions....but whenever recycle the application pool from IIS it starts working again....

Answer 1

refer This Link

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Answer 2

Thanks,
Can you tell me how to use this command with a textbox

regionTableAdapter.Insert(5, "NorthWestern");

can i write textbox1.text, textbox2.text instead of 5 and Northwestern. I tried it but it gave me error( I was explicitly converting the textboxes to int32)

????

Answer 3

Hi Waqas,

Please refer the below links

http://www.c-sharpcorner.com/uploadfile/mimrantaj/connect-to-access-database-in-C-Sharp-and-ado-net/

http://msdn.microsoft.com/en-us/library/aa288452%28v=vs.71%29.aspx

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Thanks