Facing Obstacle To Install Pyodbc And Pymssql In Ubuntu 16.04

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 erro

Solution 1:

For pyodbc case I 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

Solution 2:

For RH/Cent-OS/Linux use,

yum install unixODBC
yum install unixODBC-devel

Solution 3:

Try this without utf16:

According to @jinksPadlock I have successfully installed:

sudo apt-get install unixodbc-dev