[freetds] Forcing usage of sp_cursorprepare / sp_cursorexecute system procedures with SQL Server
Sebastien FLAESCH
sf at 4js.com
Thu Dec 13 05:20:45 EST 2007
Dear all,
In our Native SQL Server interface using ODBC (MDAC), we used to set
SQL statement attributes like:
r = SQLSetStmtAttr(stmtHandle, SQL_ATTR_CONCURRENCY,
(SQLPOINTER) SQL_CONCUR_LOCK, SQL_IS_UINTEGER);
... to force the client to use sp_cursorprepare + sp_cursorexecute
system procedures, and get better control...
The sp_cursor* procedures do for example support "SELECT ... FOR UPDATE"
statements, that are apparently not accepted by sp_prepare / sp_execute.
I could not find any sp_cursorprepare / sp_cursorexecute text in the
sources so I guess this is not possible with FreeTDS...
Right?
Thanks
Seb
More information about the FreeTDS
mailing list