Is MS SQL Server closes cursor on every commit/rollback?

[email protected]
Newsgroups gmane.comp.db.tds.freetds
Message-ID <8699797.1256458094879.JavaMail.root@elwamui-hybrid.atl.sa.earthlink.net>
Hi, ALL,
I am trying to develop a program that will
use an ODBC connection to different DB.
It will be based on some other C++ library.

What I found is that the comment to the ODBC interface
for this library says following:

// By default, MS Sql Server closes cursors on commit and rollback.  The following
// call to SQLSetConnectOption() is needed to force SQL Server to preserve cursors
// after a transaction.  This is a driver specific option and is not part of the
// ODBC standard.  Note: this behavior is specific to the ODBC interface to SQL Server.
// The database settings don't have any effect one way or the other.
const long SQL_PRESERVE_CURSORS = 1204L;
const long SQL_PC_ON = 1L;
/* retcode = */ SQLSetConnectOption(hdbc, SQL_PRESERVE_CURSORS, SQL_PC_ON);

Is this true for all version of MS SQL Server or just for an old ones?
Is it the same for Sybase as well?

What I will gain/lose when this will be disabled?

Thank you.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.