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?
SQL Query Error
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
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
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.
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.
Option located on Miscellaneous page in the Options dialogI'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 assume you have restarted HostMonitor after you modified ini file?_____edit___ ignore added DoNotUse_SqlFetchAbsolute=1 to hostmon.ini will see if the error returns.
Regards
Alex