SQL Query Error

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
dpeterka
Posts: 13
Joined: Mon Jul 21, 2003 6:00 pm

SQL Query Error

Post by dpeterka »

Hello,

Very infrequently (once every 100 tests or so, maybe) I receive this error running a ODBC SQL Query (Oracle Driver 8.01.07.00)

Access violation at address 00000000. Read of address 00000000

HM 4.42 on W2k SP3

Any thoughts?
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

I have checked our database, checked the code, and checked several newsgroups. Nothing really useful.

Driver for Oracle 7 could produce this error, but you have Oracle 8.

Driver for Oracle 8 may crash when application uses SQL_FETCH_ABSOLUTE command. HostMonitor may use this command when perform ODBC query test (unless you mark "Do not use SQLFetchAbsolute command" option). But as I understand you do not use ODBC Query test method. You are using ODBC logging. Right? ODBC logging doesn't use SQL_FETCH_ABSOLUTE command, so I still don't know what could be the reason... :-(

Regards
Alex
dpeterka
Posts: 13
Joined: Mon Jul 21, 2003 6:00 pm

Post by dpeterka »

I am using ODBC Query, my apologies for not stating it clearly.

I'm a bit confused about the SQL_FETCH_ABSOLUTE , it's not an option in the ODBC Query nor an option in the ODBC driver. So not sure where to look

I do use the same ODBC to call several tests do you think that if the tool calls one test while another is executing that this could cause the conflict?

_____edit___ ignore added DoNotUse_SqlFetchAbsolute=1 to hostmon.ini will see if the error returns.
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

I'm a bit confused about the SQL_FETCH_ABSOLUTE , it's not an option in the ODBC Query nor an option in the ODBC driver. So not sure where to look
Option located on Miscellaneous page in the Options dialog
_____edit___ ignore added DoNotUse_SqlFetchAbsolute=1 to hostmon.ini will see if the error returns.
I assume you have restarted HostMonitor after you modified ini file?

Regards
Alex
Post Reply