Unable to install pyodbc on streamlit sharing

☁️ Community Cloud
5

Hi @randyzwitch , Thank you very much. I already figured out the pyodbc problem. But I got a new problem: Error: (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 17 for SQL Server’ : file not found (0) (SQLDriverConnect)”)

Traceback:

File "/usr/local/lib/python3.7/site-packages/streamlit/script_runner.py", line 332, in _run_script
    exec(code, module.__dict__)File "/app/pythonvscode/sqldb.py", line 12, in <module>
    conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

Can you please help me to check what’s the problem?