Getting error when executing stored procedure with ODBC Quer

General chat about HostMonitor (all messages posted before March 07, 2003 available here).
Locked
unclelude
Posts: 20
Joined: Wed Jan 22, 2003 6:00 pm

Post by unclelude »

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

However, when I test the stored with the "When x = y" condition, it runs fine.

Any ideas ?

Regards,

Adnan
KS-Soft
Posts: 12887
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Truth to say don't have any idea now, but I can try to find something. Does stored procedure returns some set of records? Do you use "Alert when field ROW:COL.." option of the ODBC test? If yes, does the same error appears when option is disabled?

Regards
Alex
unclelude
Posts: 20
Joined: Wed Jan 22, 2003 6:00 pm

Post by unclelude »

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
Locked