For cases when mxODBC's cursor.execute can't do the job, raise a warning and fall back on cursor.executedirect which is less picky. This causes a drastic improvement in passing tests.

1 files changed, 8 insertions, 1 deletions

diff --git a/lib/sqlalchemy/connectors/mxodbc.py b/lib/sqlalchemy/connectors/mxodbc.py
index ac7075209..78a1719c1 100644
--- a/lib/sqlalchemy/connectors/mxodbc.py
+++ b/lib/sqlalchemy/connectors/mxodbc.py
@@ -126,4 +126,11 @@ class MxODBCConnector(Connector):
                 version.append(n)
         return tuple(version)
 
-
+    def do_execute(self, cursor, statement, parameters, context=None):
+        # temporary workaround until a more comprehensive solution can
+        # be found for controlling when to use executedirect
+        try:
+            cursor.execute(statement, parameters)
+        except (InterfaceError, ProgrammingError), e:
+            warnings.warn("cursor.execute failed; falling back to executedirect")
+            cursor.executedirect(statement, parameters)