szymon_dybczak
Esteemed Contributor III

Hi @nanda_ ,

So basically what you need to do is to install simba odbc driver on your Azure App Service environment. Then your code should work in the same way as in your local machine.

One possibility is to use Windows or Linux Containers on Azure App Service in which you have control over what drivers or custom software to install.

In  Dockerfile you can installl databricks ODBC driver in following way (adjust driver version to your needs) :

# Install Databricks ODBC driver.  
RUN apt update && apt install -y unixodbc unixodbc-dev freetds-dev sqsh tdsodbc unzip libsasl2-modules-gssapi-mit  
RUN curl -sL https://databricks.com/wp-content/uploads/drivers-2020/SimbaSparkODBC-2.6.16.1019-Debian-64bit.zip -o databricksOdbc.zip && unzip databricksOdbc.zip  
RUN dpkg -i SimbaSparkODBC-2.6.16.1019-Debian-64bit/simbaspark_2.6.16.1019-2_amd64.deb  
RUN export ODBCINI=/etc/odbc.ini ODBCSYSINI=/etc/odbcinst.ini SIMBASPARKINI=/opt/simba/spark/lib/64/simba.sparkodbc.ini

If you're using the source code deployment option, then you can try to install Simba ODBC driver using SSH.