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