Cannot execute SQL Query.

mjhritz · Post by **mjhritz** » Thu Aug 18, 2005 9:36 am

I keep getting the following error message when Host Monitor is running as a service:

[8/18/2005 11:20:18 AM] Sys Error: Cannot execute SQL query. ErrorCode = 4294967295: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The odd thing is that if a particular member of my staff is logged onto the server where the service is running, and has Hostmonitor running in his interactive session it executes properly with the message:

[8/18/2005 11:16:36 AM] Sys SQL query executed (Action profile: "ODBC LOG")

We're running on Windows Server 2003, Host monitor version is 4.80
Thanks for any help

KS-Soft · Post by **KS-Soft** » Thu Aug 18, 2005 10:26 am

I assume you are using User DSN. Please switch to System DSN. Option located on Misc page in the Options dialog.
And do not forget to specify system data source using Windows ODBC Data Source Administrator

Regards
Alex

mjhritz · Post by **mjhritz** » Thu Aug 18, 2005 10:31 am

I am using a system DSN. We had been using a User DSN but then made the changes in the Advanced Logs section to a system DSN. I then stopped and restarted the HostMonitor service, but the error messages continue.

Thanks,
Mike

KS-Soft · Post by **KS-Soft** » Thu Aug 18, 2005 11:42 am

[8/18/2005 11:16:36 AM] Sys SQL query executed (Action profile: "ODBC LOG")
....
but then made the changes in the Advanced Logs section

Error appears when HostMonitor executes SQL Query action, right? So, why you have changed settings in the Advanced Logs section instead of changing settings for that action?
If you are using ODBC logging AND SQL Query action, you should change data source in the Options dialog AND in the alert profile.

Regards
Alex

KS-Soft · Post by **KS-Soft** » Thu Aug 18, 2005 11:44 am

if a particular member of my staff is logged onto the server where the service is running, and has Hostmonitor running in his interactive session it executes properly with the message

We do not recommend to run service and application and the same time. If you need to configure HostMonitor on remote server using Terminal Service, we would recommend to create simple BAT file that will stop service, start HostMonitor in application mode and (after you change settings and terminate application) start service again.

Code: Select all

net stop hostmonservice 
"c:\program files\hostmon\hostmon.exe" 
net start hostmonservice

Regards
Alex