Facing obstacle to install pyodbc and pymssql in ubuntu 16.04

Viewed 6088

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

pip install pyodbc

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
3 Answers

For RH/Cent-OS/Linux use,

yum install unixODBC
yum install unixODBC-devel
Related