Azure SQL Database
An Azure relational database service.
5,444 questions
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.
Error : Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll'
Raghava Sai Akula
361
Reputation points
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
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
Sort by: Most helpful
-
Alberto Morillo 33,426 Reputation points MVP2023-04-04T15:05:47.5066667+00:00 -
Raghava Sai Akula 361 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 33,426 Reputation points MVP
2023-04-04T16:47:34.0766667+00:00 Please try the troubleshooting steps provided here in StackOverflow.
-
Raghava Sai Akula 361 Reputation points
2023-04-04T18:06:59.2933333+00:00 here in StackOverflow isn't useful
-
Alberto Morillo 33,426 Reputation points MVP
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 361 Reputation points
2023-04-04T20:39:25.0166667+00:00 yes, I included it in my .vbproj file
-
Alberto Morillo 33,426 Reputation points MVP
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,017 Reputation points Microsoft Employee2023-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,017 Reputation points Microsoft Employee
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
Sign in to comment -