[freetds] Want to use fast forward cursors (SQL_CO_FFO) and MARS

Sebastien FLAESCH sf at 4js.com
Sat May 3 02:59:49 EDT 2008

Hi all,

I had a little review of our code and found a unique "FIXME" to resolve:

     } else {                    / * Use fast forward cursor * /
         r = SQLSetStmtAttr(st->stmtHandle, SQL_SOPT_SS_CURSOR_OPTIONS,
                            (SQLPOINTER) SQL_CO_FFO, SQL_IS_UINTEGER);
         if (!SQL_SUCCEEDED(r)) {
             DBGMSG(1, "Could not set SQL_SOPT_SS_CURSOR_OPTIONS");
             return -1;

With the native SQL Server ODBC drivers (SNAC and MDAC), this option
can be used from the odbcss.h header.

Are there any plans to support this?

BTW: What about MARS (Multiple Active Result Sets)?

Thanks a lot!

More information about the FreeTDS mailing list