django 连接 sqlserver

django 连接 sqlserver

1. 版本
   django 3.0
   sql server 2016
   windows 10

2. 下载安装包
   django-mssql-backend 2.8.1
   pyodbc 4.0.32
   直接pip install 就可以

3. 查看odbc驱动
   再python脚本中运行查看自己的odbc的驱动
   import pyodbc
   print(pyodbc.drivers())
   [‘SQL Server’, ‘SQL Server Native Client 10.0’, ‘Microsoft Access Driver (*.mdb, *.accdb)’…]

4. 测试
   import pyodbc
   sql_conn = pyodbc.connect(
   ‘DRIVER={SQL Server Native Client 10.0};SERVER=127.0.0.1;DATABASE=mydb;UID=sa;PWD=password;’)
   curs = sql_conn.execute(‘select getdate()’)
   print(curs.fetchone())
   sql_conn.close()
   正常输出时间就测试成功了
   5.配置
   ‘default’: {
   ‘ENGINE’: ‘sql_server.pyodbc’,
   ‘NAME’: ‘mydb’,
   ‘USER’: ‘sa’,
   ‘PASSWORD’: ‘password’,
   ‘HOST’: ‘127.0.0.1’,
   ‘PORT’: ‘1433’,
   ‘OPTIONS’: {
   ‘driver’: ‘SQL Server Native Client 10.0’,
   },
   },

完成