View previous topic :: View next topic |
Author |
Message |
dpeterka
Joined: 21 Jul 2003 Posts: 13
|
Posted: Wed Jun 09, 2004 2:54 pm Post subject: SQL Query Error |
|
|
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? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12793 Location: USA
|
Posted: Thu Jun 10, 2004 4:10 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
dpeterka
Joined: 21 Jul 2003 Posts: 13
|
Posted: Thu Jun 10, 2004 6:52 pm Post subject: |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12793 Location: USA
|
Posted: Fri Jun 11, 2004 3:42 pm Post subject: |
|
|
Quote: | 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
Quote: | _____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 |
|
Back to top |
|
|
|