Cursor Concurrency (ODBC)

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

Cursor operations, like cursor types, are affected by the concurrency options set by the application. Concurrency options are set using the SQL_ATTR_CONCURRENCY option of SQLSetStmtAttr. The concurrency types are:

  • Read-only (SQL_CONCUR_READONLY)

  • Values (SQL_CONCUR_VALUES)

  • Row version (SQL_CONCUR_ROWVER)

  • Lock (SQL_CONCUR_LOCK)

Cursor Properties

Community Additions

ADD
Show: