Database monitor - change the value of the timeout?

[Michael Finney]

Database monitor -
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation
This seems to happen when my computer is busy doing something when my oracle ASP application is running.
http://www.freshwater.com/support/notes/noteTN10389.htm says:
"This is an error seen for a Database monitor running against an Oracle database. Change the value of the timeout for the monitor. Either increase the value or set the value to 0. If you choose to set the value to 0, be careful it may cause monitors to skip."
That sounds right on the money. So How do I change the value of the timeout for the monitor? Are they talking about my Oracle/ODBC driver?
Michael

[Beksy Kurian]

Which version of ODBC you are using?
Beksy

[Michael Finney]

The ODBC/Oracle Drive is version 8.01.74.00
Oracle in OraHome81
Oracle Corporation
SQORA32.DLL
Dated 7/24/2001
Should I disable the "Enable Query Timeout" flag in the ODBC Driver Configuration of the driver?
[ June 19, 2002: Message edited by: Michael Finney ]

[Beksy Kurian]

Yes, that's right. Deselect 'enable query time out'.
and ...
change the CPTIMEOUT in the registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in OraHome8I
Beksy

[Michael Finney]

change CPTimeout to what? It is 60 now. Change it to 0? or 300?
On my box CPTimeout resides in
//HKEY_LOCAL_MACHINE//SOFTWARE//ODBC//ODBCINST.INI//Oracle in OraHome81
Thanks. I appreciate your assistance.

[Beksy Kurian]

change it to 0. Default is 60. I think 0 means unlimited.
Beksy

[Michael Finney]

That sounds right to me. Thank you so much.