Re: ODBC auto-commit mode nonfunctional with Microsoft?

"James K. Lowden" <[email protected]> Sun, 9 Mar 2008 14:03:46 -0400

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.  

--jkl