Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' :

[zmsoft]

Hi there,

My cluster version is 15.4 LTS, and the workspace has UC enabled. When I used the initialization script to install ODBC Driver 17 for SQL Server, there were no errors and the cluster started successfully. But when I use ODBC Driver 17 for SQL Server in the notebook to update the database record, I get an error.

Any suggestion?

Thanks & Regards

[MarcusC]

Is it not possible for you to use the built in sqlserver-driver?
Sample code for reading below

spark.read \

        .format("sqlserver") \

        .option("host", "xxx.database.windows.net") \

        .option("database",database) \

        .option("dbtable", table) \

        .option("accessToken", access_token) \

        .option("encrypt", "true") \

        .option("hostNameInCertificate", "*.database.windows.net")

[zmsoft]

Hi @MarcusC 

I want to update database rows using the odbc driver