Hello,
I am using Oracle ODBC Driver inside a VB App.
I need to time my SQL queries and if they take more than 2 minutes, I need to cancel the query.
The commandtimeout property of the ADO control works just fine. My problem is that ODBC displays a message that 'User requested cancel of current operation'.
Even though I have a error handler, ODBC displays this message and then returns control to the error handler.
The ODBC message is kinda misleading because the user did not cancel the operation, it was a timeout.
Does anybody know how I can prevent the ODBC from doing this ?
Thanks in advance for the help,
- Subha
Nothing is impossible, even the word impossible says I'm possible.
I am using Oracle ODBC Driver inside a VB App.
I need to time my SQL queries and if they take more than 2 minutes, I need to cancel the query.
The commandtimeout property of the ADO control works just fine. My problem is that ODBC displays a message that 'User requested cancel of current operation'.
Even though I have a error handler, ODBC displays this message and then returns control to the error handler.
The ODBC message is kinda misleading because the user did not cancel the operation, it was a timeout.
Does anybody know how I can prevent the ODBC from doing this ?
Thanks in advance for the help,
- Subha
Nothing is impossible, even the word impossible says I'm possible.