freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] ODBC: Multiple active statements,
Peter Harvey, 10/18/2003
- <Possible follow-up(s)>
- RE: [freetds] ODBC: Multiple active statements, ZIGLIO Frediano, 10/20/2003
Archive powered by MHonArc 2.6.24.