diff options
| author | Gord Thompson <gord@gordthompson.com> | 2020-09-17 10:32:31 -0600 |
|---|---|---|
| committer | Gord Thompson <gord@gordthompson.com> | 2020-09-17 11:42:06 -0600 |
| commit | dcd2be16b9c9a6a52b6bb7e144e31998b7cee631 (patch) | |
| tree | e95ec8fb6fda83ead83997e34b5467aec02ed28d /lib/sqlalchemy/connectors/pyodbc.py | |
| parent | d5c89a541f5233baf6b6a7498746820caa7b407f (diff) | |
| download | sqlalchemy-dcd2be16b9c9a6a52b6bb7e144e31998b7cee631.tar.gz | |
Add support for Azure authentication options
Fixes: #5592
Change-Id: I0688e5ea0fc6b01a0b72f397daea8f57a2ec0766
Diffstat (limited to 'lib/sqlalchemy/connectors/pyodbc.py')
| -rw-r--r-- | lib/sqlalchemy/connectors/pyodbc.py | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/lib/sqlalchemy/connectors/pyodbc.py b/lib/sqlalchemy/connectors/pyodbc.py index 96ac0c1f1..e1a7c99f4 100644 --- a/lib/sqlalchemy/connectors/pyodbc.py +++ b/lib/sqlalchemy/connectors/pyodbc.py @@ -95,9 +95,15 @@ class PyODBCConnector(Connector): user = keys.pop("user", None) if user: connectors.append("UID=%s" % user) - connectors.append("PWD=%s" % keys.pop("password", "")) + pwd = keys.pop("password", "") + if pwd: + connectors.append("PWD=%s" % pwd) else: - connectors.append("Trusted_Connection=Yes") + authentication = keys.pop("authentication", None) + if authentication: + connectors.append("Authentication=%s" % authentication) + else: + connectors.append("Trusted_Connection=Yes") # if set to 'Yes', the ODBC layer will try to automagically # convert textual data from your database encoding to your |