带有外部连接SQL SERVER的Django 2.2

Question

在我的python 3.7 + Django 2.2中，我需要连接到外部SQL Server。它不是Django的主要数据库(仍保留在Postgres中)。我只需要在视图上做一些查询。

我在Debian 9上，我正在尝试安装软件包来添加sql服务器连接，但我在google上找不到关于Debian软件包的安装指南。

我尝试安装：

pip install pyodbc
pip install django-mssql-backend

但编译失败。我想我遗漏了一些系统库。

更新1

apt-get install unixodbc-dev
pip install pyodbc
pip install django-mssql-backend

这解决了库的安装问题。现在我在尝试连接到数据库时遇到了问题：

Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")

谢谢。

Answer 1

您缺少允许unixodbc连接到SQL Server的基础驱动程序。You can find instructions to install the Microsoft ODBC driver here。

Debian的简短版本，来自以下链接：

sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#Debian 8
curl https://packages.microsoft.com/config/debian/8/prod.list > /etc/apt/sources.list.d/mssql-release.list

#Debian 9
curl https://packages.microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list

#Debian 10
curl https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install unixodbc-dev
# optional: kerberos library for debian-slim distributions
sudo apt-get install libgssapi-krb5-2

祝好运!