Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC: Multiple active statements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC: Multiple active statements
  • Date: Mon, 20 Oct 2003 11:40:28 +0200

>
> FreeTDS: latest from cvs
> Server: MS SQL v7.0
> Database: Northwind
> Interface: ODBC
>
> The MS ODBC driver does not support multiple active statements due to
> optimizations. This prevents queries from being nested under certian
> circumstances. To get around this I do the following;
>
> // PAH - temp to get MS SQL Server to allow multiple active statements
> SQLSetStmtAttr( hStmt, SQL_ATTR_CURSOR_TYPE,
> (SQLPOINTER)SQL_CURSOR_DYNAMIC, SQL_IS_INTEGER );
> SQLSetStmtAttr( hStmt, SQL_ATTR_CONCURRENCY,
> (SQLPOINTER)SQL_CONCUR_ROWVER, SQL_IS_INTEGER );
>
> This works on MS ODBC driver but does not seem to overcome
> limitation on
> FreeTDS.
>
> Peter
>

FreeTDS still do not support cursors... Bill is working on this stuff
but you have to wait 0.63 version...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page