ODBC Logs with Log Analyzer setup

mrmichaelbeck · Post by **mrmichaelbeck** » Tue Jun 03, 2014 3:39 pm

Hi there,

I'm trying to setup ODBC logging. I've got a SQL Server and a System DSN which is pointed to my log database. I've created the columns that it asks for in the ODBC setup screen. However, it appears that the software cannot see the System DSN. Hostmonitor is running on a different computer. The database is running on another different computer (the System DSN connects to it happily). I am on a workstation trying to configure the logging to the database. I've even tried creating a System DSN on my workstation to see if that would make things work. Nothing yet. Any ideas?

Michael

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 03, 2014 3:42 pm

System DSN should be created on HostMontior system.
Please check HostMontior system log:
HostMonitor menu View -> system log
or
RCC: menu View -> Auditing tool -> Recent syslog..

mrmichaelbeck · Post by **mrmichaelbeck** » Tue Jun 03, 2014 3:47 pm

Thanks for the response. I appreciate it.

I do have the DSN on the Hostmonitor system - forgot to mention that.

The audit repot screen makes no mention of me trying to connect via ODBC, unfortunately. It's filled with generating HTML and DBF reports, along with a few connection establilshed or failed messages from one of the other techs.

When I try to run a test from the setup screen I get this:

---------------------------
Error
---------------------------
Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie
---------------------------
OK
---------------------------

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 03, 2014 3:56 pm

May be you have configured System DSN using 64bit ODBC Data Source Administrator?
Please use 32bit ODBC Data Source Administrator (C:\WINDOWS\SysWOW64\odbcad32.exe)
Quote from manual:
==================
Windows x64
HostMonitor is 32bit application that can be started on 64bit Windows OS. 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).
==================

mrmichaelbeck · Post by **mrmichaelbeck** » Tue Jun 03, 2014 4:03 pm

Good call. I've switched the DSN over to the 32 bit version and I've removed the 64bit one. Unfortunately, I still get the same error message.

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 03, 2014 4:08 pm

Do you use RCC to setup ODBC logging? RCC located on HostMonitor system?

mrmichaelbeck · Post by **mrmichaelbeck** » Tue Jun 03, 2014 4:10 pm

No, I've been using the RCC on my workstation. I'll try on the hostmonitor machine...

mrmichaelbeck · Post by **mrmichaelbeck** » Tue Jun 03, 2014 4:34 pm

That did it. Thanks for your help!

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Jun 03, 2014 4:41 pm

You are welcome!