Since I implemented some additional ODBC SQL-Test-Queries, akter a while, the oracle server test response with "no answer". Pressing the Test-Button in Oracle Server Test-Config dialog, I receive the following message box: Access violation at address 778CB2B9 in module 'ntdll.dll'.Write of address 6600EC7C.
HostMon 3.56 is running on a W2K Workstation with SP2, Oracle Client 8.0.5
I configured test of oracle server as a mastertest for each ODBC-SQL-query test. It seems, that in case the sql query takes a long response time even the oracle server test hangs.
is there anyone who has/had same issue?
Thanks
Roman
Oracle Server test hangs up
As I remember one customer had similar problem with Oracle Client 8.
Oracle ODBC driver does not support SQL_FETCH_ABSOLUTE command. HostMonitor tries to use this command and if driver returns error, HostMonitor use cycle with SQL_FETCH_NEXT command. It looks like some bug in errors handler (I mean ODBC driver) can be reason to failure after many calls.
That's why we implemented special option to avoid this problem. Please add "DoNotUse_SqlFetchAbsolute=1" parameter into Misc section of hostmon.ini file, and restart HostMonitor.
It helped to bhugh, hope it will help in your case as well.
Regards
Alex
Oracle ODBC driver does not support SQL_FETCH_ABSOLUTE command. HostMonitor tries to use this command and if driver returns error, HostMonitor use cycle with SQL_FETCH_NEXT command. It looks like some bug in errors handler (I mean ODBC driver) can be reason to failure after many calls.
That's why we implemented special option to avoid this problem. Please add "DoNotUse_SqlFetchAbsolute=1" parameter into Misc section of hostmon.ini file, and restart HostMonitor.
It helped to bhugh, hope it will help in your case as well.
Regards
Alex