ODBC Test Error

dan-dotson · Post by **dan-dotson** » Tue Oct 22, 2013 6:26 pm

Hello:

I need to setup a test to query a Windows 2008 SQL database. I am going to run the query through an ODBC connection on the server where Hostmonitor is installed. I'm using the built-in SQL Server driver to setup the DSN. The connection test within the ODBC config window works.

When I setup my test, I can select the correct data source (my ODBC connection), however, when I click "test" I get "Error 4294967295: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie".

I've tested a number of different things, but I'm hitting a wall. Any ideas?

Thanks,

Dan

KS-Soft · Post by **KS-Soft** » Wed Oct 23, 2013 5:30 am

HostMonitor version?
HostMonitor started as service or application?
Did you setup test using HostMonitor or RCC?
Did you setup test to be performed by HostMonitor or RMA?
Did you set data source using User DSN or System DSN?

User DSN/System DSN
As you know Windows has system data source names (System DSN) and user data source names (User DSN). System data sources are local to a computer but not user-dedicated; any user with privileges can access a system DSN. User data sources are local to a user and accessible only by the specified user. Using "User DSN/System DSN" option you can choose which data sources list will be used by HostMonitor.
Please note if you start HostMonitor as service, it will not be able to use User DSN. Only System DSN will be used . So, if you are planning to start HostMonitor as service and as regular application, use "System DSN" option. In this case HostMonitor will work equally in both modes.

Regards
Alex

KS-Soft Europe · Post by **KS-Soft Europe** » Wed Oct 23, 2013 7:22 am

What Windows do you use x64 or x86?
If you are using 64bit Windows, please use 32bit ODBC Data Source Administartor (default location: C:\WINDOWS\SysWOW64\odbcad32.exe) to setup User/System DSN.

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).

dan-dotson · Post by **dan-dotson** » Wed Oct 23, 2013 9:09 am

HostMonitor version?
HostMonitor started as service or application?
Did you setup test using HostMonitor or RCC?
Did you setup test to be performed by HostMonitor or RMA?
Did you set data source using User DSN or System DSN?

We are using 9.5. It is installed on Windows 2003 (32 bit)
Hostmonitor is started as a service.
Test was setup with the RCC. I'm not sure what the functional difference of setting it up in either place would be.
Data source is a system DSN.

dan-dotson · Post by **dan-dotson** » Wed Oct 23, 2013 9:13 am

Interesting... Your question of whether we used RCC or Hostmonitor to setup the test piqued my interest. I attempted to run the test from Hostmonitor itself and it appears to be working...

KS-Soft · Post by **KS-Soft** » Wed Oct 23, 2013 9:37 am

Tests (monitoring) are performed by HostMonitor and RMA.
If you are using RCC, some GUI "tests" buttons send requests without HostMonitor.
If RCC installed on the same system, it should work anyway...

Regards
Alex

dan-dotson · Post by **dan-dotson** » Wed Oct 23, 2013 11:30 am

Thanks for the help!

KS-Soft · Post by **KS-Soft** » Wed Oct 23, 2013 11:42 am

No problem

Regards
Alex