freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?
Date: Sun, 9 Mar 2008 14:03:46 -0400

Frediano Ziglio wrote:
> > I was experimenting with the DB session's
> > "auto-commit mode". I found that it doesn't work for MS SQL, and it
> > does work for Sybase.
>
> Too few for a bug report... auto-commit mode is the default mode (not
> default is no auto-commit). 95% of unittests work in auto-commit mode so
> why do they work?? Perhaps the problem is in no auto-commit...

I believe he means that passing SQL_ATTR_AUTOCOMMIT with
SQL_AUTOCOMMIT_OFF/SQL_AUTOCOMMIT_ON to SQLSetConnectionAttr doesn't
change whether or not the connection is in autocommit mode.

--jkl

[freetds] ODBC auto-commit mode nonfunctional with Microsoft?, James K. Lowden, 03/07/2008
- Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?, Frediano Ziglio, 03/09/2008
  - Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?, James K. Lowden, 03/09/2008
    - Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?, ZIGLIO, Frediano, VF-IT, 03/10/2008
    - Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?, ZIGLIO, Frediano, VF-IT, 03/10/2008