Sql server error 3704: Operation is not allowed when the object is closed
Posted on 2008-10-30
I have an asp system that works 24/7.
At random times, usually once per day or so and usually first thing in the morning, I'll get this error. The same code has
worked perfectly thousands of times so I assume its not the code.
Where it happens, I do the following
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "mytable", Conn, adOpenKeyset, adLockOptimistic, adCmdTable
RS.Fields("pid") = person_id
RS.Fields("f_flag") = family_flag
RS.Fields("time") = Now()
...and get the error on the update. Nothing fancy, just simple code.
It seems to hang for up to a minute or so, then errors.
If the person hits 'Back' and retries the post, it works the second time really fast.
Works 20-30 times, then fails the next time. No events in my event logs show any problems.
SQL Server 2005 is running on Windows 2003 server
Asp is running on a different Windows 2003 server with iis