freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Fw: FreeTDS patch for MSSQL autocommit

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Fw: FreeTDS patch for MSSQL autocommit
Date: Tue, 1 Apr 2008 10:11:52 +0200

>
> Peter Deacon wrote:
> > On Mon, 31 Mar 2008, James K. Lowden wrote:
> > > I received the attached AUTOCOMMIT patch by private mail. I don't
> > > know how/if it would be merged with CVS HEAD and/or 0.82.
> > > What do you think?
> >
> > Running profiler on .82 both FreeTDS and the MS driver sent
> the same
> > commands over the wire when switching autocommit on and off.
> >
> > XACT_ABORT is OFF by default. The driver must not enable it
> > 'implicitly' when toggling autocommit.
>
> IOW, the 0.82 driver is OK as is, and the patch should not be
> applied?
>

I would also add that changing autocommit inside a transaction is an
error to commit transaction before setting autocommit.

freddy77

Re: [freetds] Fw: FreeTDS patch for MSSQL autocommit, James K. Lowden, 04/01/2008
- Re: [freetds] Fw: FreeTDS patch for MSSQL autocommit, ZIGLIO, Frediano, VF-IT, 04/01/2008