pyodbc.Error: This app has encountered an error

Community Cloud
,
1

pyodbc.Error: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs (if you’re on Streamlit Cloud, click on ‘Manage app’ in the lower right of your app).

Traceback:

File "/home/adminuser/venv/lib/python3.11/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 600, in _run_script
    exec(code, module.__dict__)File "/mount/src/yorumanalizi/pages/login.py", line 139, in <module>
    main()File "/mount/src/yorumanalizi/pages/login.py", line 125, in main
    PgCon01 = ms.connect(constr)
              ^^^^^^^^^^^^^^^^^^

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'driver' : 
file not found (0) (SQLDriverConnect)")

[packages.txt]
unixodbc-dev
mssql-tools
msodbcsql17
sqlcmd

[requirements.txt]
pandas
plotly
streamlit
streamlit_navigation_bar
streamlit_extras
pyodbc
numpy
keyboard

please help me

2

Welcome to the community, @hilalkcky! :hugs:

To fix that pyodbc.Error, did you first check the ODBC driver installation on your system? You can check this by running odbcinst -j in your terminal to see if the driver is properly listed in your odbcinst.ini files.

Let me know.

Charly

3

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.