FreeTDS Development Group

[Peter Harvey <pharvey AT codebydesign.com>]

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