Regarding Database Connection using pyodbc
Hello, I need to run my code in dataiku which requires connection to a database. The code requires "'sudo apt-get install unixodbc" to run. However, even after installing pyodbc in dataiku, I am facing error (Attached). Please guide through the process if any
.
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 DataikerOptionsHi,
The error message is not coming from DSS, but from the actual script. It points at the server where the notebook is running missing the unixODBC development headers.
This is installed running the 'sudo apt-get install unixodbc-dev ' package. Yet, you mention you've already followed this step.
Did you update the server after that, i.e. 'sudo apt-get update'?
If that does not work, can you doublechecked the configuration steps in the Microsoft's docs: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16