Hello all, I am currently designing a custom activity which requires an interaction with an SQL database. As such, I have added the ‘Microsoft.Data.SqlClient’ dependency to my project. I have researched plenty of topics online and it seems that there is an issue with loading a dependency, namely, …

Spent a fair while on this one. Seems there is some kind of issue with Studio loading the SNI dll. The UiPath database activities have manual workarounds in code to load the library if its a windows machine. You could pull their activity pack into your project or pinch their source code if you wer…

@DM1 , Tried this solution? [image] Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies Activities Hi @indiedev91 You went down a rabbit hole with this one sweat_smile For some context, in case anyone is still wondering what is wrong here. …

@DM1 Please check this [image] Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: The specified module could not be found. (0x8007007E) Activities The solution was to download the the DLL and place it in the UiPath folder (C:\Program Files\…

Hello @Anil_G , I have indeed tried this, did not work either. @ashokkarale , I had checked that post before as well and I tried setting the dll in the nupkg in the same way as the database activities shown in that post. Still not able to fix the issue.

@DM1 Are you getting the error while installing the package itself? Or while running? Cheers

The error occurs while running the activity. All the unit tests pass on Visual Studio, so the issue is caused by some other issue on Studio.

@DM1 What version are you on? Fid you try with the latest versions? Cheers

I have tried with both versions 5.2.1 (latest) and 4.1.0 (the one that UiPath uses on package version 1.7.1 of the UiPath.Database.Activities) of Microsoft.Data.SqlClient. I have also tried deplying on Studio version 2024.10.1 and 2023.10.2

I can’t seem to find any official documentation on this issue, nor a proper solution on the forums. We will probably discontinue these custom activities going forward. Thank you

UiPath Custom activity with Microsoft.Data.SqlClient

Help Activities

Anil_G (Anil Gorthi) July 29, 2024, 5:32pm 3

@DM1

Please check this

Cheers

Topic		Replies	Views
Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies Activities database , activities , studio	7	6504	April 30, 2024
Converting Custom Activitys to .Net 6.0 Activities database , custom-activitys	4	997	August 10, 2023
System.Data.SqlClient / sni.dll in coded automation -> Unable to load DLL 'sni.dll' Studio	2	276	September 26, 2024
Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies: The specified module could not be found. (0x8007007E) Activities database , activities , question	5	953	April 12, 2024
"Bad IL format. The format of the file 'C:\Users\username\.nuget\packages\uipath.database.activities\1.7.0\lib/net5.0-windows7.0/runtimes/win-x64/native/Microsoft.Data.SqlClient.SNI.dll' is invalid" Activities	5	1448	March 19, 2025

UiPath Custom activity with Microsoft.Data.SqlClient

Related topics