Facing obstacles to install pyobbc and pymssql in ubuntu 16.04

Question

I want to install pyodbc to connect the mssql server using sqlalchemy I work in search engines and try in several ways, for example

pip install pyodbc 

Follow this link Pyodbc installation error on Ubuntu 16.04 with Sql server installed but didn’t solve errors like below

 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 

Answer 1

For the pibackback case, I used the command

 sudo apt-get install unixodbc-dev pip install pyodbc 

and capable of successfully installing pyopbc, but faced with my comment problem (unable to transfer data to the mssql server)

For pymssql, I used the command

 sudo apt-get install freetds-dev pip install pymssql 

after which you can successfully install pymssql and paste the data into the mssql server

Answer 2

Try this without utf16:

According to @jinksPadlock, I successfully installed:

 sudo apt-get install unixodbc-dev