We support a V6 program. The code does a query, gets the result set, and performs a .delete on the result, no problem. We updated to SQL server 2005, and the .delete suddenly fails with the vague "The statement has been terminated" error.
I rewrite the code to do a Delete query instead of a .delete on the rdo resultset as a workaround - this works. But I know there are several more instances waiting for me. Any ideas?