FYI sudden can't open lib error in docker

[nomorepanic]

Hello,
I just wanted to leave this here so that people may find the solution right away. I found the solution on another post somewhere on the internet, but I've lost the original source.

If you're getting this error:

Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1'

Check your base image as libmsodbcsql-17 may not support it; for example it doesn't suppport Debian Trixie yet.

[gordthompson]

Thanks for the heads-up. Interestingly, mssql-python does work with Trixie:

(venv) root@fea6016ca61e:/# head -n 1 /etc/os-release    
PRETTY_NAME="Debian GNU/Linux 13 (trixie)"
(venv) root@fea6016ca61e:/# python
Python 3.13.5 (main, Jun 25 2025, 18:55:22) [GCC 14.2.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import mssql_python
>>> cnxn = mssql_python.connect("Server=192.168.0.199;UID=scott;PWD=tiger^5HHH;Database=test;Encrypt=no;")
>>> crsr = cnxn.cursor()
>>> crsr.execute("select @@version").fetchval().split("\n")[0]
'Microsoft SQL Server 2019 (RTM-CU3) (KB4538853) - 15.0.4023.6 (X64) '