pyodbc 是 python 常用的SQL Server驱动,但是这个包在 Ubuntu 下无法直接安装,需要先安装数据库驱动。
sudo curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
sudo curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sudo apt-get install -y unixodbc-dev
pip install pyodbc
安装完毕后在 python3 交互命令行执行下面脚本。
import pyodbc
print(pyodbc.drivers())
输出:
['ODBC Driver 17 for SQL Server']