Re: ODBC auto-commit mode nonfunctional with Microsoft?

"ZIGLIO, Frediano, VF-IT" <[email protected]> Mon, 10 Mar 2008 11:48:52 +0100

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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