RMA: 301 - Access violation at address 00404F84 in module rm

forke · Post by **forke** » Thu Apr 28, 2005 4:25 am

RMA: 301 - Access violation at address 00404F84 in module rma.exe. Read of address 014D0000

I get this error when i want to check the SQL-version of my SQL-server. I have a working system DSN to the SQL-server and i use the query SELECT @@VERSION. This query works on the SQL-server locally, but not trough the RMA-agent.

Any idea?

KS-Soft · Post by **KS-Soft** » Thu Apr 28, 2005 7:41 am

"my SQL-server" means "MySQL"?
Please read this article: http://www.ks-soft.net/cgi-bin/phpBB/vi ... php?t=1255

Regards
Alex

forke · Post by **forke** » Thu Apr 28, 2005 9:04 am

no it's not MySQL, it is a normal Microsoft SQL-server and i use the RMA for testing that SQL-server

KS-Soft · Post by **KS-Soft** » Thu Apr 28, 2005 9:18 am

H'm..
What version of the agent (RMA) do you use?
ODBC driver version?

Regards
Alex

forke · Post by **forke** » Thu Apr 28, 2005 9:29 am

3.12 RMA-agent

Microsoft SQL Server ODBC Driver Version 03.70.1140

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

KS-Soft · Post by **KS-Soft** » Fri Apr 29, 2005 2:49 pm

I checked source codes, don't see any error. Probably some problem with ODBC driver...
Some ODBC drivers do not process correctly SQL_FETCH_ABSOLUTE command. HostMonitor tries to use this command and if driver returns error, HostMonitor use cycle with SQL_FETCH_NEXT command. It works fine with most ODBC drivers. However ODBC driver which comes with Oracle client v.8 (and may be some other drivers) has bug in error handler. This bug can cause ODBC driver to crash.
That's why we have implemented "Do not use SQLFetchAbsolute command" option for HostMonitor. But this option is not available for RMA.

Could you try to perform this test directly by HostMonitor (with "Do not use SQLFetchAbsolute command" option enabled)? If it will work fine, we implement the same option for the agent.
Option located on Misc page in the Options dialog.

Regards
Alex