SQLGetData not working with SQLFetchScroll when trying to fetch results from a storedproc

Hi
I have been trying to get a NVARCHAR(MAX) column data from a stored
proc using sqlgetdata after doing a sqlfetchscroll but it fails with
the error msg "Result set not generated by a select statement". I am
able to make it work with SQLFetch but I need to use fetchscroll
because I need to use scrolling.The query being executed is a stored
proc. The above problem doesnt occur with normal selects on tables. Is
SQLGetdata incompatible with Stored proc results ? The stored proc
simply does a select on a table and returns the result.
I use sql server 2005 with sql native client. Using
Static_cursor(not using forward only). Any help will be appreciated.

Thanks
Avinash

.

Loading