Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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 10:37:29 +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.
>

I downloaded OTL and looked at the source. The problem is that FreeTDS
does not set properly auto-commit to off before connection but only
after.
I think it will require some extra rows... just set implicit transaction
after connection if auto-commit is off... change similar to
change_database call...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page