search

Azure-App-Service / python

base image for Python on linux app service
Apache License 2.0
54 stars 49 forks source link

pyodbc runtime is not supported #14

Closed gangularamya closed 5 years ago

gangularamya commented 5 years ago

Most of the webapps in Python would try to connect external database using pyodbc Looks like we are Unable to use pyodbc as Python Image doesn't have unixodbc installed in App Container https://github.com/mkleehammer/pyodbc/wiki/Install

I think we might need to add below commands as mentioned in above link..

RUN apt-get install g++ unixodbc-dev

image

JennyLawrance commented 5 years ago

Ack, taking a look.

martincabello commented 5 years ago

Any updates on this? I have been trying and trying to deploy my flask app on azure app service, but this is major step on the way. Everything works if I leave out the dependency on pyodbc

kfolkes commented 5 years ago

I would like an estimated update on this as well.

JennyLawrance commented 5 years ago

Estimated release time, in the next 2-3 weeks.

dsalamancaMS commented 5 years ago

Running into same issue, Im not able to connect to my Azure SQL database due to the lack of unixodbc.

AcerbragTI commented 5 years ago

Any news?...

clauney commented 5 years ago

Same issue here. @JennyLawrance - any update?

martincabello commented 5 years ago

Hey! Any news??

JennyLawrance commented 5 years ago

Yes, can you try now? All our scale units are upgraded, let me know if you still run into issues.

martincabello commented 5 years ago

I m on it. Will update asap. EDIT: THANK YOU! It seems to be working. Can someone else confirm?

chriswue commented 5 years ago

I can confirm that this works for me. I have just deployed a working python flask app on Linux based app services using pyodbc to connect to an Azure hosted MS SQL database, connecting like this:

pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
JennyLawrance commented 5 years ago

Thanks for the confirmation @martincabello @chriswue Closing the issue.

JennyLawrance commented 5 years ago

Thanks @gangularamya for reporting this and help make the product better.

thetestgame commented 4 years ago

This issue seems to have come back in a new form. You can not install pyodbc in the default container due to missing dependencies.

jaceaser commented 4 years ago

Yes, I am having the same issue setting up a new appservice.

Relent97 commented 4 years ago

I am also having the same issue

Relent97 commented 4 years ago

I m on it. Will update asap. EDIT: THANK YOU! It seems to be working. Can someone else confirm?

Hi @martincabello please can you share how you deployed the app, was it through docker or azure cli.

A github link would be tremendously appreciated please

martincabello commented 4 years ago

Hey. I cant really recall by now. It was a school project. I think it was through Azure Web UI for webapps and then we used the UI again to hook it up for auto deploy from our repo on github.

mitchellpalmer commented 4 years ago

Hi there. I am having a similar problem to this which I detailed in this SO question. Does anyone have any insights?