ODBC Support for Pagination of Data

Data pagination is a feature controlled by the client application.

If the client software supports pagination (like Crystal Reports or the direct resultset processor in code), then they will be able to see the data after the first page. Once the first page has been processed, the second page will automatically be requested by the client side driver.

If the client does not support paging, then the client will most likely freeze until all the data is sent to the client (this is what Excel does). However, if paging is supported by the client, it is very important to process the data as soon as possible. If a 5 minute delay is detected across pages (2,000 rows), the server will assume the client has died and closes the query.