pyodbc.Error: ('01000', “[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)”)

General
3

I came across this recently. For whomever needs this:
Version → Driver Name
ODBC Driver 17 → ODBC Driver 17 for SQL Server
ODBC Driver 18 → ODBC Driver 18 for SQL Server
And here’s Microsoft’s documentation on how to install their driver on linux.

Here’s my docker file snippet that handles ODBC Driver from Microsoft, where VERSION_ID is the os version provided as an ARG variable:

ADD "https://packages.microsoft.com/config/debian/${VERSION_ID}/packages-microsoft-prod.deb" ./
RUN dpkg -i ./packages-microsoft-prod.deb \
    && rm ./packages-microsoft-prod.deb \
    && apt-get update \
    && apt-get upgrade -y --no-install-recommends \
    && ACCEPT_EULA=Y apt-get install -y --no-install-recommends \
        libgssapi-krb5-2 \
        msodbcsql18 \
        unixodbc \
        unixodbc-dev  \
    && rm -rf /var/lib/apt/lists/* \

This works on python:3.12-slim.