You need to look at your odbc settings.

On the performance screen access the advanced screen.

On this screen you need to change the Large Objects Threshold.

Place a tick on Use blocking wsith a fetch row of 1.

It is the settings on this screen that will enable you to retrieve greater number of records.

Note that the number of records returned varies depending on the size of the data returned.