โ09-26-2024 08:13 PM - edited โ09-26-2024 08:27 PM
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
โ09-27-2024 01:01 AM
Is it not possible for you to use the built in sqlserver-driver?
Sample code for reading below
โ09-27-2024 02:34 AM
Hi @MarcusC
I want to update database rows using the odbc driver
4 weeks ago
Is there any update on this issue? is it solved?
4 weeks ago - last edited 4 weeks ago
In Unity catalog environment, if you want to using odbc driver to update database rows, you need to create a volumn, and put the odbc install script file to volumn, then add allow list. After that you can modify computer configuration to add init script. When odbc driver install successfully, you can using odbc driver now.
4 weeks ago
thanks for your quick response..
so if I understand correctly, you are asking to create an init script and put it in UC Volume, and then use that path in the DBK cluster's init script?
and as teh INIT script are you referring to something like this?
4 weeks ago
Also is INIT script route is the only route? or is there any other option available?
the reason I am asking, some time back we had a call with DBK and then they mentioned like usage of INIT script is not the right way or so.. cant recall exact explanation though.
4 weeks ago
I think INIT script is the only way, because when you run the script in notebook, you will get error message, it says you are not root need password.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group