ODBC Cursor Model

ODBC supports a cursor model that allows several types of cursors, scrolling within a cursor, several concurrency options, and single-row as well as bulk fetches. Unlike SQL Server 6.x, ODBC does not have explicit APIs to declare, open, and close cursors. Cursors are automatically created for you when you issue a SQLExecDirect or a SQLPrepare plus SQLExecute that is based on the specified statement options.