ODBC Query - Oracle

[V Arun]

Alex,

I have just upgraded Hostmonitor from Ver 4.80 to 6.54. Everything is fine, except the ODBC query test is not working. ODBC connectivity is fine but query is returning the following error.

Query executed, value in the filed specified: inaccessible value

This is for all query tests. Everything was fine with the earlier version. Highly appreicate your help.

Regards,
Arun.

[KS-Soft]

HostMonitor returns such error in 2 cases
- ODBC function SQLDescribeCol fails
- ODBC function SQLFetchScroll fails
As I remember Oracle ODBC driver incorrectly processes SQL_FETCH_ABSOLUTE command . That's why HostMonitor offers "Do not use SQLFetchAbsolute comand" option. Option located on Misc page in the Options dialog.
Probably you have installed new HostMonitor into different folder instead of normal upgrade and some options are different? Could you check ODBC options on Misc page in the Options dialog?

Regards
Alex

[V Arun]

Hi Alex,

I have done a standard upgrade and in the same folder as the earlier one. All settings are the same including Options -> Misc -> ODBC tests & logging. 'User DSN' and 'do not use SqlFetchAbsolute command' are already selected.

Thanks,
Arun

[KS-Soft Europe]

Query executed, value in the filed specified: inaccessible value

Such error may appear when query returns empty recordset. Could you verify the query returns truly data?

Regards,
Max