Cursor Programming Details (ODBC)
Choosing the correct cursor type can improve application performance. Under certain conditions, SQL Server may implicitly convert a cursor type when you execute an SQL statement that is not supported by the cursor type you requested.