Re: ODBC auto-commit mode nonfunctional with Microsoft?

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