freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] ODBC auto-commit mode nonfunctional with Microsoft?
Date: Mon, 10 Mar 2008 11:48:52 +0100

>
> 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.
>

Fixed. See http://freetds.sourceforge.net/post82.diff.gz

freddy77

[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