python - pyodbc - error while running application within a container

Question

I am having a python application that uses mssql - instead of using pymssql, i was trying pyodbc. There seems to be no problems while running the application in a Windows local machine. While deploying the application in a dev env packaged as a container, I see the following errors.

from pyodbc import Error
2017-04-14T13:58:28.858638588Z ImportError: Error loading shared library libodbc.so.2: No such file or directory (needed by /usr/local/lib/python3.5/site-packages/pyodbc.cpython-35m-x86_64-linux-gnu.so)

The docs require me to install the database drivers along with pyodbc.

initial check looks good to me - images shared object dependencies and sym links

Answer 1

The ubuntu environment is not having the odbc library, so it need to be installed using

sudo apt install unixodbc-dev 

once installed update the ubuntu using

sudo apt-get update

It will resolve the issue.

For further reading go to this link