KS-Soft

Alex,

I think I have fixed the problem. The stored procedure was generating a system message before returning the recordset, when I was deleting a #temp table in the code. I have chenged the stored procedure and it is working now.

Thanks,

Adnan

Alex, I have an ODBC Query Test, which executes a stored procedure as follows. exec SysAdmin..Job_Monitor_Interval @jobname = 'FX Broadcast and Status Job', @view='T' I am getting the following error when the job runs. Error: [Microsoft][ODBC SQL Server Driver]Prepared statement is not a cursor- spe...

I have a "send e-mail" action for each test. Do I have to "create" a seperate profile for each test ? can't I use the same profile and just change the "Subject Text". If first is the answer, then it means that I will have to have as many profiles as the tests, which is ...

Alex, I think it should be quite easy to recreate. I have two tests. Both of them have different DataSource Names, Test Names, Comments, and when x = y test conditions. The problem is with the "Subject" text. It takes the "Subject" text from the latest entry made to HM. For examp...

Alex,

It seems that e-mail notification picks up the "Subject" text from the previos e-mail notification that was sent out. Is that possible ? It also overwrites that entries for the custom configuaration.

Hi Alex, I think the code needs a little bit of tweeking. If you have a couple of lines of SQL code in HM, it removes the space between the lines. For example, the code select * from tbl1 where a = 1 will become select * from tbl1where a = 1 to test it, enter few lines of code in HM, then do a cut/p...

Hi Alex,

You are correct, HM expects all the code in one line. I tried your suggestion and it worked. I am very greatful for your help.

Thanks,

Adnan

Alex,

I downloaded the file and now I am using HM 3.65

Tried, but same error "Incorrect Syntax near 'emmWirelessType_EwnIDFK' with and without SQLFetch... option.

Hi Alex, 1. The link , http://www.ks-soft.net/download.hm366.zip does not work. 2. What version of HM do you use? 3.56 3. The following SQL creates the cartesian product. SELECT 'norcomq' as protcol, FROM FX_PRD05..tblWooStatusLog (NOLOCK) INNER JOIN FX_PRD05..vewEmpModem (NOLOCK) ON FX_PRD05..tblWo...

Hello Alex, I have tried both tests and they both pretty much give the same error number, though with different text. Here are the details. I tried the following SQL SELECT 'norcomq' as protcol, datediff(mi, MAX(dateadd(hh, -5, tblWooStatusLog.wslInsertedWhen ) ), getdate() )as MinutesPast , MAX(dat...

Alex,

I just tested my SQL with two downloaded ODBC Query Tools, Query Tool (ODBC) 3.5.7.9; and SQL Query Tool (ODBC) 4.1. It worked in both of them, so now I am thinking may be something in HostMonitor is not configured properly for ODBC ?

Hi Alex, I tried a simple SQL, SELECT count(*) from tblModem, and it worked fine. I think the problem is between NATIVE SQL code and ODBC code. The SQL I am having problems with, works fine in SQL Query Analyzer, but it won't work in HostMonitor because HM uses ODBC. I will have to test my SQL for O...

Hi Alex,

I am using SQL 7 & SQL 2000. I also have SQL 2000 installed on my desktop.

As per my previous question, how can I test my SQL for ODBC compliance ? any tools or utilities. I have only worked in the SQL Enterprise and SQL Query Analyzer environment.

Hi Alex, I get the following error in a dialog box: Error 4294967295 [Microsoft][ODBC Driver Manager] Function Sequence Error I don't even know how to test my code for ODBC compliance or how to test my SQL so that it can work in Host Monitor. Any ideas. I really like Host Monitor, but this has put a...

Hello, I am trying to run the following SQL, but it gives me an error. The code runs fine via SQL Query Analyzer. This is pure SQL Server code. Do I have to follow a certain syntax for ODBC ? If yes, then this puts a huge, limit on what we can do with host monitor. SELECT 'mobitex' as protcol, dated...