VS 2003 C++, ODBC
I see this error sometimes, I need to know what's causing this and how to deal with it.
I have 4 threads, each has its own db connection, query statements etc.
I'm calling a stored procedure repeatedly, committing every 15 seconds.
At 15 writes/sec frequency this error occurs 5-10 times an hour, usually in bursts within just 1 minute.
At 100 writes/sec it occurs 20 times more often.
This behavior is the same for different database instances.
Here's the error:
[Microsoft][ODBC SQL Server Driver]Operation canceled
Any help is appreciated.