Unable to use sqlcmd command shows libodbc.so.2

Question

Whenever I tried to use the sqlcmd command in my terminal im getting and error like "sqlcmd: error while loading shared libraries: libodbc.so.2: cannot open shared object file: No such file or directory"

Answer 1

It seems you didn't install the unixodbc-dev package which depends on the libodbc1 package and contains the missing shared library.

You can install it with

sudo apt update
sudo apt install unixodbc-dev

Related:

• Install the Microsoft ODBC driver for SQL Server (Linux)