What is the correct Dockerfile to install pyodbc on python:3.10.9-slim-buster image?

Question

I have been using this guide for Debian 10. I also needed install g++ for the pyodbc package to be installed.

I am using this dockerfile:

FROM python:3.10.9-slim-buster

RUN apt-get update -y && apt-get install -y curl gnupg g++ unixodbc-dev
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
RUN curl https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list 

RUN exit
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get install -y msodbcsql18
# optional: for bcp and sqlcmd
RUN ACCEPT_EULA=Y apt-get install -y mssql-tools18
RUN echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrc
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
# optional: for unixODBC development headers
RUN apt-get install -y unixodbc-dev

I am getting the error:

Login timeout expired (0) (SQLDriverConnect)

So what exactly is the problem? – Mureinik May 20 '23 at 18:57 — Mureinik, May 20 '23 at 18:57

score 0 · Answer 1 · answered May 20 '23 at 19:48

This worked:

FROM python:3.10.9-slim-buster

RUN apt-get update -y && apt-get install -y curl gnupg g++ unixodbc-dev
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
RUN curl https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list 

RUN exit
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get install -y msodbcsql17

COPY /requirements.txt /  

COPY /odbc.ini / 
RUN odbcinst -i -s -f /odbc.ini -l
RUN cat /etc/odbc.ini

Followed instructions here and here. on configuration and installation respectively.

What is the correct Dockerfile to install pyodbc on python:3.10.9-slim-buster image?

1 Answers1