Use django-pyodbc-azure:
pip install django-pyodbc
pip install django-pyodbc-azure
Microsoft recommend solution for Python connect to SQL Server: pyodbc
Settings.py:
DATABASES =
'default': {
'NAME': 'guest',
'ENGINE': 'sql_server.pyodbc',
'HOST': '127.0.0.1',
'USER': 'sa',
'PASSWORD': 'brassaikao.idv.tw',
'PORT': '1433',
'OPTIONS': {
'driver': 'ODBC Driver 17 for SQL Server',
},
}
}

Leave a comment