KS-Soft

Great. I have downloaded and tested. Problem "Undocumented" ODBC_UseDoubleSlash option directs HostMonitor to replace \ (back slash) with \\ in every variable used in SQL query. This may be necessary for some SQL servers, e.g. MySQL 5.0. "Undocumented" means that the option is no...

KS-Soft wrote:Yes, %MasterTest% variable represents name of the 1st master test. Its not a bug.

Ofcourse its not a bug.

Exactly: I'm creating module for mx-bb portal www.mx-system.com . I'm using mx-portal for our pages and I need include hostmonitor into portal. Web service is running, but some peoples that should look into hostmonitor could not have rights to edit. Web service refresh pages and I don't need it. Reg...

KS-Soft wrote:May be in next version

Should be

Will be in next version

Yes, Like "15,234,432455".
Using for my own report.

Ok I will Use %TaskComment% and %CommentLine1% .. 99.

But better will be used by IDs.

When I log MasterTest, than I become Name of the master test. More tests can have same name. What I need to do, when I have more than one master tests. In macro variable is only first master test name. How can I create macro variable for master test ID, and give in this variable more then one ID of ...

When you implement feature with \\?

KS-Soft wrote:You should read more carefully
"if there are more than 20 consecutive ODBC errors" - means HostMonitor cannot execute SQL Query, e.g. SQL server crashed

Regards
Alex

Thanks,
just now I can look to my DB Guru and ask him.

Regards
Culprit

if there are more than 20 consecutive ODBC errors occur, HostMonitor suspends ODBC logging for 10 min. It helps to avoid reduction of performance when SQL Server unavailable. If you correct problem (e.g. restart SQL Server or correct mistake in SQL Query), you may resume ODBC logging manually using...

If variable always returns number, you may use int or bigint. Otherwise I recommend to use varchar or datetime type. Be carefull with datetime variables. Remember about "Use fixed date & time format" option. That everything I know, I look for something what can help me. And I want not...

Hi,
I'm looking for description of data types and lenght of each macro variable to log into MS SQL over ODBC.

I know, that command to log could be max long 4096 chars.

Could someone help me?

I am afraid \\ will not work for MS SQL, so there is no universal solution. We have to implement some options (switches) for different servers... Regards Alex OK, Could you post me what exaclty you send in variable %FullPath%? When I create function for escaping chars from \<char> to \\<char> I did...

Thanks for answer.
I need to find some solution that will be working everywhere.

Sometimes save with \
some\Z .. saves with backslash
some\0 .. saves with backslash
some\O .. no backslash

I figured it out. It is a mySQL "problem". Using MS SQL it works fine. FYI: I used the FullPath var in a ODBC connection to the mySQL database in advanced logging with the latest version of the Host Monitor. Insert into hmlog (eventdatetime, testname, status, AlertThreshold, klant, method...