diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2020-10-14 12:05:40 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2020-10-14 13:14:42 -0400 |
| commit | 01633d94a526eb304729ed95dfbf6780c30dd258 (patch) | |
| tree | 8fae01cdefde93729f87d3f20efdd40bc3cfcc97 /lib/sqlalchemy/dialects/mssql/pyodbc.py | |
| parent | 3bdf56dc7d4624b8b1b07c9e49e945dfe6a14e62 (diff) | |
| download | sqlalchemy-01633d94a526eb304729ed95dfbf6780c30dd258.tar.gz | |
Add SQL Server 01000 disconnect
Fixes: #5646
Change-Id: I25fcba7cf866871f1232b586e7e604162bd8cc43
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql/pyodbc.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/pyodbc.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/pyodbc.py b/lib/sqlalchemy/dialects/mssql/pyodbc.py index 8bc318ea0..dac6098c4 100644 --- a/lib/sqlalchemy/dialects/mssql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mssql/pyodbc.py @@ -52,7 +52,7 @@ name must be URL encoded which means using plus signs for spaces:: Other keywords interpreted by the Pyodbc dialect to be passed to ``pyodbc.connect()`` in both the DSN and hostname cases include: -``odbc_autotranslate``, ``ansi``, ``unicode_results``, ``autocommit``, +``odbc_autotranslate``, ``ansi``, ``unicode_results``, ``autocommit``, ``authentication`` (e.g., ``authentication=ActiveDirectoryIntegrated``). Note that in order for the dialect to recognize these keywords (including the ``driver`` keyword above) they must be all lowercase. @@ -451,8 +451,9 @@ class MSDialect_pyodbc(PyODBCConnector, MSDialect): def is_disconnect(self, e, connection, cursor): if isinstance(e, self.dbapi.Error): code = e.args[0] - if code in ( + if code in { "08S01", + "01000", "01002", "08003", "08007", @@ -461,7 +462,7 @@ class MSDialect_pyodbc(PyODBCConnector, MSDialect): "HYT00", "HY010", "10054", - ): + }: return True return super(MSDialect_pyodbc, self).is_disconnect( e, connection, cursor |