Error when accessing stored procedures

[mukjp2]

Whenever I try to access these particular stored procedures from within Crystal Reports 9, I am hit with an "Invalid Cursor" error. The error appears to be coming straight from the SQL server. Some stored procs work and I cannot determine what's causing it!

thanks,
Kyle

 

[synapsevampire]

Here's an article that references SQL Server Invalid Cursor error, search for Invalid Cursor:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_general_sql_server_error.pdf

Hard to say without seeing the SP.

-k