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

[narendra11]

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

[Brahmareddy]

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