Error : Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

Question

Error : Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

Raghava Sai Akula 406

Hi , I am having an legacy vb.net application which is using .net 4.7.2.

I replaced System.Data.Sqlclient with Microsoft.Data.Sqlclient(v 2.1.5) to make my application connectionstrig(password less). I made the Microsoft.Data.Sqlclient changes in dev env and the application is loading perfectly in my localhost but in test env it throws error. Screenshot when browsed locally with in IIS of my VM User's image

Note : My Env is completely Azure (Azure Sql, Application in IIS in a Azure VM) and I don't have any SSMS or Sqlserver on my Azure VM. My Application is working fine in my Local Dev Env

1 answer

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Have you tried to install the driver from here? Finally this seems to be a bug with .Net Framework 4.7.2 as demonstrated here.

Raghava Sai Akula 406 Reputation points

2023-04-04T15:20:19.6133333+00:00
I initially installed Microsoft.Data.SqlClient V 5.1.1 from NuGet), as It didn't work, later I installed Microsoft.Data.SqlClient V 2.1.5 from NuGet ) in both cases it automatically installs Microsoft.Data.SqlClient.SNI Version 5.1.0 & 2.1.1 respectively. though Issue is always with Microsoft.Data.SqlClient.SNI.x64.dll
current Config

<package id="Microsoft.Data.SqlClient" version="2.1.5" targetFramework="net472" /> <package id="Microsoft.Data.SqlClient.SNI" version="2.1.1" targetFramework="net472" />
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-04-04T16:47:34.0766667+00:00

Please try the troubleshooting steps provided here in StackOverflow.
Raghava Sai Akula 406 Reputation points

2023-04-04T18:06:59.2933333+00:00

here in StackOverflow isn't useful
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-04-04T20:31:38.1866667+00:00
Is your project including this?

<ItemGroup> ... <PackageReference Include="Microsoft.Data.SqlClient" Version="5.1.0" /> </ItemGroup>
Raghava Sai Akula 406 Reputation points

2023-04-04T20:39:25.0166667+00:00

yes, I included it in my .vbproj file
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-04-04T21:06:51.18+00:00

Finally this seems to be a bug with .Net Framework 4.7.2 as demonstrated here.
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-07T19:15:00.2366667+00:00

@Raghava Sai Akula is your issue fixed? You need to ensure Microsoft.Data.SqlClient.SNI.x64.dll gets copied to your bin folder. You can do it via a post-build step. The x64 DLL is available in Microsoft.Data.SqlClient.SNI NuGet package.

Regards

Geetha
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-04-10T15:34:05.3366667+00:00

@Raghava Sai Akula We haven't heard back from you. Just wanted to check if you had the chance to check my response

Share via

Error : Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'

1 answer

Your answer