[freetds] Problem with freetds_0.62.4 and SQLSetStmtAttr SQL_ATTR_CURSOR_TY PE SQL_CURSOR_STATIC
freddyz77 at tin.it
Sat Jan 22 04:24:13 EST 2005
Il giorno ven, 21-01-2005 alle 13:39 -0600, kwills at mercantec.com ha
> I have a short "C" program that compiles and runs under Windows 2003.
> This same short "C" program compiles and mostly runs under RedHat Linux 9.
> I am attempting to use the following statement:
> SqlReturn = SQLSetStmtAttr(stmt, SQL_ATTR_CURSOR_TYPE, (SQLUINTEGER
> *)SQL_CURSOR_STATIC, 0 );
> It is giving back an error of: [FreeTDS][SQL Server]Option value changed]
> The SQLSetStmtAttr was used to allow the code to do a select query that
> drove a loop with a select query.
> Because the SQLSetStmtAttr fails using FreeTDS, the application then gets a
> 2nd ODBC error.
> [[FreeTDS][SQL Server]Attempt to initiate a new SQL Server operation
> with results pending.]
> It looks like the SQLSetStmtAttr is failing using FreeTDS but succeeds when
> using Microsoft SQL Server ODBC Driver Version 03.85.1025.
> Any help to fix the FreeTDS driver problem would be appreciated.
If you want to help coding cursors you are welcome. Any patch, comment
or test case it's welcome. For example you can post your short C program
and we can adapt and include in our unit tests.
More information about the FreeTDS