I'm running HM ver 7.78 on a Windows 2003 server with an Active RMA client v 3.69 running on a Windows 2008 R2 server. I'm trying to setup an ODBC test. The ODBC works great on the server - but when I attempt to pull down the available data sources on an ODBC Query test, I get the message RMA Error: 301 Cannot retrieve ODBC sources list. I've tried running the RMA service as an administrator and no luck. Other RMA tests are working without issue. Any suggestions on how to get the ODBC query test to work?
Thanks,
Steve
Cannot Retrieve ODBC sources list
I'm still getting the error but I've gotten around it. Originally when I just typed in the DSN name I was getting an error: "Specified DSN contains an architecture mismatch between the driver and application". After looking this error up I found that I had setup the DSN as 64 bit vs 32 bit which is what Host Monitor is running under. To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe.
After I created a 32 bit DSN name, I was able to manually enter the connection in Host Monitor and the query ran. The other ODBC queries I run with an Active RMA all pull down the list of DSN names - does this have something to do with the new server being 64 bit vs 32 (which all of the other servers I monitor are)?
After I created a 32 bit DSN name, I was able to manually enter the connection in Host Monitor and the query ran. The other ODBC queries I run with an Active RMA all pull down the list of DSN names - does this have something to do with the new server being 64 bit vs 32 (which all of the other servers I monitor are)?
-
KS-Soft Europe
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
HostMonitor is 32 bit application and it can use only 32 bit ODBC drivers.
Quote from the manual:
http://www.ks-soft.net/hostmon.eng/index-sysreq.htm
========================
Windows x64:
* HostMonitor is 32-bit application, however it can be used on Windows x64 Edition running on x86-64 (AMD64) systems (not on Itanuim/IA-64). E.g. you can start HostMonitor on Windows XP Professional x64 Edition or Windows Server 2003 x64 Edition.
* If you are using Windows x64 Edition and you want to setup ODBC Logging or ODBC test method, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).
========================
Quote from the manual:
http://www.ks-soft.net/hostmon.eng/index-sysreq.htm
========================
Windows x64:
* HostMonitor is 32-bit application, however it can be used on Windows x64 Edition running on x86-64 (AMD64) systems (not on Itanuim/IA-64). E.g. you can start HostMonitor on Windows XP Professional x64 Edition or Windows Server 2003 x64 Edition.
* If you are using Windows x64 Edition and you want to setup ODBC Logging or ODBC test method, you should setup ODBC datasources using 32-bit ODBC Data Source Administrator (e.g. C:\WINDOWS\SysWOW64\odbcad32.exe).
========================