MSSQL with adodbapi does not commit

When using an MSSQL database via adodbapi, transactions are not committed. The original symptom was that tables were not actually created as requested.

The problem is that mssql.py contains some clever workarounds for pymssql transaction problems, but these are not applicable to adodbapi. The fix I suggest has MSSQLDialect which just uses the default do_begin/do_commit/do_rollback. Derived from this is PyMSSQLDialect that has the smart overrides for pymssql. The appropriate dialect is selected at runtime.

Comments (6)