Installing ODBC Driver 17 for SQL Server in Streamlit sharing

[philipnye]

Hi there,

Love the tool that you’ve built.

I’m trying to make my app that connects to a SQL database available via Streamlit sharing.

It makes use of ODBC Driver 17 for SQL Server.

Per here, I think the way to install this on Streamlit sharing(/Debian) is to add msodbcsql17 to a packages.txt file.

I’m getting the following error though:

Unable to locate package msodbcsql17

(NB: There’s a suggestion here that mssql-tools needs to be added to a packages.txt file, but the link above suggests to me that it’s msodbcsql17 that’s needed. In any case, adding mssql-tools to packages.txt results in a similar error to the one given above.)

My app can be found here:

philipnye/streamlit

Is there any assistance you’re able to offer?

Thanks in advance.

[philipnye]

In case anyone stumbles across this topic, it now has a fix - described here: How to add an ODBC driver to streamlit cloud?. (Note the comment about potentially needing to delete and redeploy your app to get it to work.)