Search found 20 matches

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 ...

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 fo ...

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". ...

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 &quo ...

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 cust ...

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 ...

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 'norcom ...

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, ...

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 HostMo ...

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 ...

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 o ...

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 ...

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 ye ...