Ok I have a webpage which is just a large form. One of the questions takes a large amount of data (the users are basically pasting a 10k text page into the textbox). THe problem is this....they can fill out their form and paste their mondo report into question 27 and submit fine. The data is saved and everything is hunky dory. However, once they have submitted the form with the mondo text pasted in, then whenever they try to resubmit afterwards it timeouts with...
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/dencom_web/preventive_dentistry/submit_preventive_dentistry.asp, line 251
BTW: line251= Conn.Execute(sqlstr_update_record)
Now if I take the exact query that the asp page is trying to run and just paste it into the sql server query analyzer , it runs instantly with no problems. I dont get it? IIS and the sql server are on the same box so why is this happening? BTW , total size of the data in the form is approx 11kb.