"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"

Help Activities
1

These are not solutions to this issue. Something is wrong with UiPath.Database.Activities 1.7.1

Changing to Microsoft.Data.SqlClient is to resolve a different error message. Simply deleting and reinstalling UiPath.Database.Activities 1.7.1 doesn’t fix it.

The only “fix” I’ve found is using UiPath.Database.Activities 1.5.0

2

Changing to version 1.5.0 also did not help… Has anyone been able to work around this?? Thanks!

3

Reinstalling library UiPath.Database.Activities did not download the Microsoft.Data.SqlClient.SNI.dll so now I am having error “Failed to load library (ErrorCode: 126)”. Would you know how to solve it now?
Thanks
Patrik

4

Hi, did you manage to figure this out? I am also experiencing the same issue. Thanks

5

Try these:

  • Converting a project that has activities with the System.Data.SqlClient connection option from Windows - Legacy to the Windows compatibility throws an execution error unless you change the connection option to Microsoft.Data.SqlClient.
  • Similarly, converting a Windows - Legacy project that has activities with the MySql.Data.MySqlClient connection throws an error unless the connection option is set to System.Data.Odbc (the MySQL ODBC Driver needs to be installed on the machine using the Microsoft ODBC Data Source Administrator).

Reference: Activities - Release Notes

If at the runtime the error is not causing issues, the error can be skipped.

6

I think this is an issue during publication.
The path is C:aasdfasdf\asdfasdf\adsfasdf\lib/adf/asdf/.rrr.dlll

Note that the path is created with both forward slash up to “\lib” and backslash AFTER the “lib” folder. There is something wrong with building this path when publishing. My current project has a few dependencies that contain the “sub” dependency UiPath.emgucvbundle.

C:\Users\specificUser.nuget\packages\UiPath.emgucvbundle\1.3.0\lib/net6.0/concrt140.dll

I am seeing the same thing. I don’t think it is dependency specific as I have seen several posts with the same issue but different dependency.

I have already tried removing all dependencies, deleting UiPath.emgucvbundle from the path, closing the project, restarting and reapplying all dependencies. I get the same issue.

Can we get someone to look into this.

Thanks
JT