在 ubuntu 16.04 中安装 pyodbc 和 pymssql 遇到障碍

2021-09-12 00:00:00 python ubuntu sql-server

我想安装 pyodbc 以使用 sqlalchemy 连接 mssql 服务器我在谷歌上搜索并尝试了多种方式，例如

I want to install pyodbc for connection mssql server using sqlalchemy I am googling and tried in several ways like 

pip install pyodbc

按照此链接Pyodbc 安装错误在安装了 Sql Server 的 Ubuntu 16.04但还没有解决下面抛出类型错误

Followed this link Pyodbc installation error on Ubuntu 16.04 with Sql Server installed but have not solved below type error thrown 

src/pyodbc.h:56:17: fatal error: sql.h: No such file or directory
  compilation terminated.
  error: command 'gcc' failed with exit status 1

  ----------------------------------------
  Failed building wheel for pyodbc

推荐答案

对于 pyodbc 案例我使用命令

For pyodbc case I used command 

sudo apt-get install unixodbc-dev
pip install pyodbc

并且能够成功安装pyodbc但面临我的评论问题(无法将数据推送到mssql服务器)

and able to success pyodbc installation but facing my comment problem (not able to push data into mssql server)

对于 pymssql 我使用了命令

For pymssql i used command 

sudo apt-get install freetds-dev
pip install pymssql

然后就可以成功安装pymssql并将数据插入到mssql服务器

then able to success pymssql installation and data insert into mssql server

相关文章