SQL Query Error

dpeterka · Joined: 21 Jul 2003 Posts: 13

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 · Joined: 03 Apr 2002 Posts: 12793 Location: USA

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 · Joined: 21 Jul 2003 Posts: 13

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 · Joined: 03 Apr 2002 Posts: 12793 Location: USA