Hi, 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 gues…

I think you have to delete your app and re-deploy, so that the new version of the container gets used. Could you try that @Mark_Von_Oven and @Andy_J ? The driver should be the official MS SQL driver.

I think the driver should be present on the image now, though the connection guide won’t make it to the documentation for a little bit yet. Essentially, you would pass all the parameters to the connection string (instead of referring to a DSN), and you can use st.secrets within Cloud to keep the cre…

Hi @randyzwitch Unfortunately I still have the same error (unable to locate package), could you confirm which driver has been added? Once I get this to work, I’m happy to post an example connection string while awaiting the official guide release. Thanks Andy

Same here @randyzwitch . I assumed we could just include all three packages that @Andy_J references above in the packages.txt file and reboot…but still getting the exact same errors as before (which are different than Andy sees. Here’s a snippet of the log: [log]

Thanks @randyzwitch that worked. @Mark_Von_Oven you now only need msodbcsql17 in your packages.txt file. Adding unixodbc causes a clash now I believe but it is no longer needed.

Thanks for confirming @Andy_J ! @snehankekre is working on the connection guide, so if you have any other tips, he’d be a great person to contact to make sure they get into our docs :slight_smile:

Guys - I’ve been so busy building cool new stuff over the last week that I forgot to say thank you. Appreciate the quick response here and everything is working great (with the exception of the fact that i need to get better at closing connections before they timeout on me and hose everything up) …

That’s fantastic news, thanks @Mark_Von_Oven !

Hey @Andy_J , @Mark_Von_Oven , @randyzwitch , thanks so much for sharing this info - it’s allowed me to get one step closer to connecting to an Azure database. I wonder if one of you, Andy or Mark, would mind sharing your connection string (with sensitive details removed)/anything else you’ve had to …

@philipnye No problem…here is the exact connection string I’m currently using in my code. All dynamic variables are set within the secrets file. Some tips on those variables: server: I use a string that is a combo platter of ‘servername, port’ (example - ‘ my-sqlserver.database.windows.net , 143…

How to add an ODBC driver to streamlit cloud?

Community Cloud

Andy_J January 18, 2022, 3:46pm 5

Thanks for the reply Randy.

That’s great news, I look forward to testing it out next week sometime.

Topic		Replies	Views
Installing ODBC Driver 17 for SQL Server in Streamlit sharing Community Cloud	1	1525	February 15, 2022
Streamlit / SQL Server Using Streamlit	5	1659	February 15, 2022
Unable to install pyodbc on streamlit sharing Community Cloud	8	3510	January 21, 2021
Streamlit Cloud + SQL Server Community Cloud streamlit-cloud	2	584	April 28, 2023
ODBC driver installation error in streamlit share Community Cloud	1	305	September 4, 2023

How to add an ODBC driver to streamlit cloud?

Related topics