search

michiya / django-pyodbc-azure

Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
https://pypi.python.org/pypi/django-pyodbc-azure
BSD 3-Clause "New" or "Revised" License
321 stars 140 forks source link

Question: Always Encrypted Support #178

Open PA-LynnPettis opened 6 years ago

PA-LynnPettis commented 6 years ago

Does django-pyodbc-azure support always encrypted with SQL Server 2016 and SQL Server 2017 servers?

rogress commented 5 years ago

We are about to find out this weekend, we are going to test it. I'll report back.

PaszaVonPomiot commented 5 years ago

Yes. We use always encrypted connection settings on SQL Server 2016 and 2017.

nyashaChiza commented 1 year ago

l am connecting to the sql server using ssms ad it only allows a connection if l set the option encrypt connection to false, l want to connect using django-pyodbc-azure , how do l set the encrypt connection to false, l tried several ways ad l keep getting the error: django.db.utils.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'user'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute (0); [28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'user'. (18456); [28000] [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute (0)")