create mssql.mxodbc dialect

Issue #1710 resolved
Former user created an issue

Create an mssql dialect which uses the mxodbc connector, which will require getting the existing (untested, not being used) connector.mxodbc module to be revamped.

Work on this started at the PyCon 2010 SQLAlchemy sprint; basic functionality is in place for creating connections, handling inserts (using pyodbc ScopeIdentity approach), but many tests are still failing and one of the tests causes a deadlock (test_dialect.test_mssql.TypesTest.test_autoincrement).

Base tests are passing 100% Engine tests have 15 errors and 8 failures SQL tests have 26 errors and 3 failures Dialect tests have 2 errors, 2 failures, and one SkipTest (to prevent deadlock)

Total tests using mssql+mxodbc

Ran 2158 tests in 175.665s

FAILED (SKIP=1, errors=198, failures=14)

Comments (4)

  1. Mike Bayer repo owner

    this dialect is in and has decent test support now. Still needs some work with unicode data, those issues can be separate tickets if needed.

  2. Log in to comment