RE: SQLGetData not working with SQLFetchScroll when trying to fetch re

I believe the design of SNAC driver should allow that. In other words, this
may be a bug in SNAC.
So, could you please give us a program to reproduce the problem?

Thanks,
Ming.
MDAC Team, Microsoft.



"Avinash Achar" wrote:

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