I'm using a cursor adapter now to set the number of rows to fetch as well as the fetch as needed flag.

When I was working with SQL Pass through I didn't see a way to set either of these for a cursor generated on the fly.

I'm was using the SqlSetProp to set both the Asynch and BatchMode flags but there are no settings for the fetch properties that I could find.