Oracle ODBC driver timeout property

[JtheRipper]

Hi there,

I am using the Oracle 9.2 ODBC driver. We are experiencing "timeout" errors when a certain query runs from the application using the ODBC driver. When executing the same query in sqlplus it runs fine, although it does take a while.

I saw that I can disable the "query timeout" property of the ODBC driver, but don't want to do that. I would rather like to set the timeout to a value of my choice, if at all possible. Can I set the query timeout value somewhere?

Any input very much appreciated.

Thanks,
J.

 

[gillianleec]

There are three places that I have found to change this setting. First: in the individual query properties, there is property called ODBC timeout. Second and third: In Regedit, do a search for ConnectionTimeout and QueryTimeOut. Right click and modify. You can change the base to Decimal and set these to what you want. I recommend setting them to zero.