ODBC Test and RMA Agent

StevenE · Post by **StevenE** » Wed Jan 11, 2006 1:56 pm

I setup an ODBC test to a MS Access Database and it works fine from The Host Monitor pc.

When I select the remote agent to run the test, I get RMA: Test Error.

I did setup the Same ODBC settings on both Host Monitor and the RMA Agent machine.

Both machines can access the files fine.

Is there some part I am missing ?

Thanks
StevenE

StevenE · Post by **StevenE** » Wed Jan 11, 2006 1:57 pm

I forgot,

I am running RMA Agent 3.15 and Host Monitor 5.71

Also the ODBC and SQL Query for the Agents is enabled.

Thanks
StevenE

KS-Soft · Post by **KS-Soft** » Wed Jan 11, 2006 4:29 pm

Just "RMA: Test Error" and no further explanation?
Normally this error should be followed by error description returned by ODBC driver.

Regards
Alex

KS-Soft · Post by **KS-Soft** » Thu Jan 12, 2006 7:03 am

PS. Try this update www.ks-soft.net/download/rma315c.zip

Regards
Alex

StevenE · Post by **StevenE** » Thu Jan 12, 2006 3:28 pm

With 3.15c

I now get this message,

Unknown RMA: 301 - [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data ODBC test (NB-03)

Thanks
Steven