App with data from SQL Database - pyodbc error

Using Streamlit
1

Hi,
I created a Streamlit App in Visual Studio Code (Python), and I deployed it on Streamlit after “creating” it in Github, however I keep getting this error when entering the app “pyodbc.OperationalError: 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).”

The data in the file is directly from a connected SQL Database/Server with Username, Password etc.

I deployed on the community cloud.
https://comparisonapp-2cdu6d4qg6b3oggwgyptgx.streamlit.app

requirements.txt: pandas
matplotlib
pyodbc

Traceback:

File "/home/adminuser/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/exec_code.py", line 88, in exec_func_with_error_handling
    result = func()
             ^^^^^^File "/home/adminuser/venv/lib/python3.12/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 590, in code_to_exec
    exec(code, module.__dict__)File "/mount/src/comparisonapp/ComparisonReportV2.py", line 32, in <module>
    df_player_stats_total, df_player_stats_avg, df_player_stats_percent, df_players, df_teams = get_data()
                                                                                                ^^^^^^^^^^File "/mount/src/comparisonapp/ComparisonReportV2.py", line 19, in get_data
    conn = pyodbc.connect(conn_str)
           ^^^^^^^^^^^^^^^^^^^^^^^^

Python version: 3.12