Azure Automation Python 3.10 ImportError: libodbc.so.2: cannot open shared object file: No such file or directory #1416
Description
pyodbc https://pypi.org/project/pyodbc/5.2.0/ can be imported to Azure automation successfully, but cannot use it in runbook.
Repro runbook script:
#!/usr/bin/env python3
import pyodbc
runtime version: Python 3.10
error message:
Traceback (most recent call last): File "/usr/src/tmp/e33fbf72-bb07-4539-b139-277bbea3feb4/runbooks/testpy.py", line 3, in import pyodbc ImportError: libodbc.so.2: cannot open shared object file: No such file or directory
it works well with Python 3.8.
It seems an issue with libodbc, but cannot apply the workaround in #1133 because we cannot install anything in automation sandbox.
Need fix it.