Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with freetds_0.62.4 and SQLSetStmtAttr SQL_ATTR_CURSOR_TY PE SQL_CURSOR_STATIC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with freetds_0.62.4 and SQLSetStmtAttr SQL_ATTR_CURSOR_TY PE SQL_CURSOR_STATIC
  • Date: Sat, 22 Jan 2005 10:24:13 +0100

Il giorno ven, 21-01-2005 alle 13:39 -0600, kwills AT mercantec.com ha
scritto:
> 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.
> [20019][[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.
>
> unixODBC_2.2.10
> freetds_0.62.4
>
> Any help to fix the FreeTDS driver problem would be appreciated.
>
> Kevin

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.

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page