I developped an app using Python 3.11 using a Sql Server DB on Azure. After deploying. When opening the app on Streamlit Cloud, I am getting the error below. the ODBC version is 18.4.1.1. Any help will be appreciated.
sqlalchemy.exc.DBAPIError : 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).
DBAPIError: (pyodbc.Error) (‘01000’, "[01000] [unixODBC][Driver Manager]Can’t
open lib ‘ODBC Driver 18 for SQL Server’ : file not found (0)
(SQLDriverConnect)")
(Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)