How do I solve this error in my Databricks Apps when using the pyodbc library? I have used an init script to install the library in my cluster, which has resolved the issue in Notebooks. However, the problem persists in Apps. I have used the following commands in my init script:

sudo apt-get update
sudo apt-get install -y libodbc2
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18

How do I solve this error in my Databricks Apps when using the pyodbc library? I have used an init script to install the library in my cluster, which has resolved the issue in Notebooks. However, the problem persists in Apps. I have used the following commands in my init script:

sudo apt-get update
sudo apt-get install -y libodbc2
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18

• databricks
• azure-databricks

Share Improve this question Follow asked Mar 14 at 13:32 Obirieni SimeoObirieni Simeo 9988 bronze badges 1

• Can you provide the exact error message? – Rakesh Govindula Commented Mar 21 at 12:40

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

I have tried the below code to install:

You can try the below at your end:

dbutils.fs.put("/databricks/init/<YourClusterName>/pyodbc-install.sh","""
#!/bin/bash
sudo apt-get update
sudo apt-get -q -y install unixodbc unixodbc-dev
sudo apt-get -q -y install python3-dev
/databricks/python/bin/pip install pyodbc
""", True)

• Restart the cluster and then import pyodbc in your code.

Results: