ODBC log test error

efiten · Post by **efiten** » Wed Feb 15, 2012 4:51 am

I'm trying to enable logging to an MS-SQL database, but i'm not able to connect. unfortunately i haven't got that much experience with SQL

I use SQL 2008 R2, made a database called "HMLOG", made an ODBC user-DSN, but then i'm stuck with the error :

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object Name 'hmlog'.

Has anyone some info about further creation of tables, or just an SQL query to create those? i want to collect as much info as possible into it.

I use HM 9.10

Erwin

KS-Soft Europe · Post by **KS-Soft Europe** » Wed Feb 15, 2012 7:41 am

Looks like there is no table "hmlog" in database.
You may create table using the following SQL query:

Code: Select all

CREATE TABLE hmlog ( 
  eventtime datetime, 
  testname varchar (100), 
  status varchar (16), 
  reply varchar(100), 
  testid int, 
  testmethod varchar(100) 
);

Please note:
1. 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.
2. 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).

Please check the manual or visit our web site for more informatio at:
http://www.ks-soft.net/hostmon.eng/mfra ... tm#odbclog

efiten · Post by **efiten** » Wed Feb 15, 2012 7:54 am

I made an mistake in the table name

I saw it when I started your query and it created a new table...

I did use a 64-bit system and used 32-bit ODBC Data Source Administrator with a system DSN.

TnX

KS-Soft · Post by **KS-Soft** » Wed Feb 15, 2012 12:01 pm

So it works fine now?

Regards
Alex

efiten · Post by **efiten** » Thu Feb 16, 2012 6:34 am

Yes, everything works fine now, over 20 ODBC connections to SQL in 'the cloud'

Our RMA agent are all used at the moment, is it possible to get extra agents? we use the enterprise edition.

KS-Soft Europe · Post by **KS-Soft Europe** » Thu Feb 16, 2012 7:39 am

Yes, everything works fine now, over 20 ODBC connections to SQL in 'the cloud'

Great

Our RMA agent are all used at the moment, is it possible to get extra agents? we use the enterprise edition.

Sure, you may purchase additional tools like RMA, RCC, e.t.c.
Please check for details at:
http://www.ks-soft.net/hostmon.eng/regmon.htm#tools