Windows10
SQL Server 2019
py -V ==== Python 3.9.2
pip -V ==== pip 21.0.1
python -m django –version ==== 3.0
pip list
—————————–
Package Version
——————– ——-
asgiref 3.3.1
Django 3.0
django-mssql-backend 2.8.1
pip 21.0.1
pyodbc 4.0.30
pytz 2021.1
setuptools 54.1.1
sqlparse 0.4.1
# import os,sys
# import pyodbc
# for drive in pyodbc.drivers():
# print(drive)
#
# SQL Server
# Oracle in XE
# MySQL ODBC 8.0 ANSI Driver
# MySQL ODBC 8.0 Unicode Driver
# SQL Server Native Client 11.0
# SQL Server Native Client RDA 11.0
# ODBC Driver 17 for SQL Server
DATABASES = {
‘default’: {
‘ENGINE’: ‘sql_server.pyodbc’,
‘HOST’: ‘DESKTOP-U31HLSASQLEXPRESS’,
‘PORT’: ”,
‘NAME’: ‘DJANGO_MSSQL’,
‘USER’: ‘sa’,
‘PASSWORD’: ‘1234567’,
‘OPTIONS’: {
‘driver’: ‘ODBC Driver 17 for SQL Server’,
},
},
}|