Skip to Content.
Sympa Menu

freetds - [freetds] ODBC: Multiple active statements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Peter Harvey <pharvey AT codebydesign.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] ODBC: Multiple active statements
  • Date: Sat, 18 Oct 2003 18:28:50 -0700

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





Archive powered by MHonArc 2.6.24.

Top of Page