ODBC Log Test returns invalid object name error

Guest · Post by **Guest** » Wed Oct 23, 2002 2:13 pm

When I run the test for the ODBC log SQL query I receive an error:
Return code 4294967295
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object Name 'hmlog'.

I am running HM 3.4 and 2k sp2

KS-Soft · Post by **KS-Soft** » Wed Oct 23, 2002 2:59 pm

You made some mistake in SQL Query. I cannot say what mistake because I do not see your SQL Query.

Regards
Alex

Guest · Post by **Guest** » Wed Oct 23, 2002 3:02 pm

This is the default string that comes with the HM installation. I had to add single quotes around date time which got rid of the original syntax error but I assumed hmlog got created when I installed HM. Here is the SQL now.

Insert into hmlog (eventtime, testname, status, reply) VALUES ('%DateTime%', '%TestName%', '%Status%', '%Reply%')

KS-Soft · Post by **KS-Soft** » Wed Oct 23, 2002 3:17 pm

No, HostMonitor's installation does not create database (it doesn't know what database do you prefer, what format do you like). Its your responsibility.

Regards
Alex