How to add an ODBC driver to streamlit cloud?


I have an app that works locally fine, but requires ‘ODBC Driver 17 for SQL Server’ to be installed to retrieve data using pyodbc when deployed. I have tried using a requires.txt file with combinations of the below (as per other posts) but it comes up with a could not be located message (I guess because Linux based).

What does everyone else do to get around this? As there must be a way to do this, any help massively appreciated.


Screenshot 2022-01-07 101337

[This is the link to the microsoft documentation.]