I have a ASPX form that when submitted does an update to a table on MS SQL Server. This works fine 99% of the time. Sometimes it times out and I cannot submit that form from that computer until I restart the server. I can go to other forms and submit which does pretty much the same thing but updates other tables. When I go back to the trouble form and try again it still times out. I then remoted to another location to try from there and it worked fine with exactly the same data. Came back to problem computer/form and still no go. I tried another browser on the same computer and no go there as well. I also tried updating another record in the same table and still got the problem.
So it seems that once the problem starts, it seems to lock any updates from just that computer and to that table. Weird!!!
I have tried recycling the Application Pool, restarting IIS, SQL Server and the Firewall (both server and local) but the only way to fix it is to restart the server.
Your help would be very much appreciated.
View Complete Post