View previous topic :: View next topic |
Author |
Message |
unclelude
Joined: 22 Jan 2003 Posts: 20
|
Posted: Thu Mar 06, 2003 10:52 am Post subject: |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu Mar 06, 2003 11:15 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
unclelude
Joined: 22 Jan 2003 Posts: 20
|
Posted: Fri Mar 07, 2003 12:01 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
|