By default, the Microsoft® SQL Server™ ODBC driver closes a statement’s associated cursor when SQLEndTran commits or rolls back an operation. Server cursors remain open after this operation if SQL_COPT_SS_PRESERVE_CURSORS has been set to SQL_PC_ON.