Need to run update statement from databricks using azure sql pyodbc connection

narendra11 — Fri, 07 Mar 2025 16:23:22 GMT

Hi All,

I was Trying to run the update statement in data bricks notebook using pyodbc connection. while i was doing I was getting following error. I need assistance to solve this.

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")

Thanks

Re: Need to run update statement from databricks using azure sql pyodbc connection

Brahmareddy — Sat, 08 Mar 2025 21:58:32 GMT

Hi Narendra,

How are you doing today? As per my understanding, It looks like your Databricks notebook can't find the ODBC Driver 17 for SQL Server. You can first check if the driver is installed by running !odbcinst -q -d in a notebook cell. If it's missing, try installing it with !sudo apt-get update and !sudo apt-get install -y msodbcsql17, then restart the cluster. Also, verify the ODBC configuration by running !cat /etc/odbcinst.ini to check if the driver is listed. If it's still not working, check your pyodbc connection string and ensure the driver name matches the installed one, like "DRIVER={ODBC Driver 17 for SQL Server}". Try these steps and see if they help!

Regards,

Brahma

topic Re: Need to run update statement from databricks using azure sql pyodbc connection in Data Engineering

Need to run update statement from databricks using azure sql pyodbc connection

Re: Need to run update statement from databricks using azure sql pyodbc connection