ODBC Database Logging

In attempting to set up the ODBC Based Logging in ServersCheck version (8.0.1) I am encoutering an issue,

when the ServersCheck software is attempting to insert an entry into the ServersCheck table with the below SQL

(as captured from SQL Server Profiler)



INSERT INTO SERVERSCHECK (TimeStamps, UnixTimeStamps, Label, Status, Errors, UID)

VALUES (zdatum,1264153914,'S01 PING','DOWN','Error: Connection to host timed out','1263228015')



The error that is being returned by the Database is:



Msg 207, Level 16, State 1, Line 1

Invalid column name 'zdatum'.



I am attempting to set the logging up on an SQL Server 2008 database.



Any help with this would be appreciated



Regards,



Stuart Ferguson

It seems like it is not picking up the date. What is the ODBC Connection string that you used?

Driver-{SQL Server Native Client 10.0}; Server={IP Here};Database={DBName};UID={User};PWD={Password}.



I selected the SQL 2008 Template from the drop down.

Download following beta build of 8.0.7 of the monitoring_thread2.exe

http://files.serverscheck.net/fixes/monitoring_thread2.exe



1) Stop the Monitoring Service

2) In the main ServersCheck directory rename your current monitoring_thread2.exe to monitoring_thread2.bak

3) Copy the downloaded one in the main directory

4) Restart service and see if it solves the issue

Unfortunately I am unable to put the beta version onto our production system at the moment. Are you able to list the changes between 8.0.5 and 8.0.7 beta ?

Changes in release 8.0.7 are not yet made public