ODBC -> MSSQL transactions (HACK)

Nathan Bird <[email protected]> Fri, 15 Jun 2007 17:54:29 -0400
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
I had some problems with transactions, here is a hack around that works
for me. It is based on the fact that apparently mssql requires the
"transaction" keyword in "commit transaction" when it is over odbc. 
ODBC actually has a different scheme for transactions based on turning
off autocommit, and then doing the commit manually with SQLEndTran or
somesuch, that looked more difficult and with this all the tests pass. :-)

clsql -> unixodbc -> freetds (0.63) -> mssql 2000

Nathan Bird