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 directorycompilation terminated.error: command 'gcc' failed with exit status 1----------------------------------------Failed building wheel for pyodbc

For pyodbc caseI used command

sudo apt-get install unixodbc-dev
pip install pyodbc

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

For pymssql i used command

sudo apt-get install freetds-dev
pip install pymssql

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