Could not load file or assembly Microsoft.SqlServer.Types

Question

I got the following error in "QGL : Shared Cargowise.Model".

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
   location: Enterprise.ZArchitecture.Schema.GlbStaffSchema..cctor()
   location: System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   location: System.Reflection.RtFieldInfo.UnsafeGetValue(Object obj)
   location: System.Reflection.RtFieldInfo.GetValue(Object obj)
   location: CargoWise.DbUpgrader.Scripts.Definitions.HRM.ManagedType`1..ctor() file C:\CW1\Shared\CargoWise.DbUpgrader\src\Scripts\Scripts.Definitions\HRM\ManagedType.cs:line 17
   location: CargoWise.DbUpgrader.Scripts.Definitions.CoreScriptIndex.<GetScripts>d__0.MoveNext() file C:\CW1\Shared\CargoWise.DbUpgrader\src\Scripts\Scripts.Definitions\CoreScriptIndex.cs:line 2407
   location: CargoWise.Glow.Model.DatabaseBuilder.OdysseyGenerator.RunScriptObjects(ILogger logger, SqlConnection connection) file C:\CW1\Shared\CargoWise.Model\src\DatabaseBuilder\DatabaseBuilder\Generator\OdysseyGenerator.cs:line 98
   location: CargoWise.Glow.Model.DatabaseBuilder.OdysseyGenerator.GeneratePrimaryDatabase(ILogger logger, String databaseName, SqlConnection connection) file C:\CW1\Shared\CargoWise.Model\src\DatabaseBuilder\DatabaseBuilder\Generator\OdysseyGenerator.cs:line 88
   location: CargoWise.Glow.Model.DatabaseBuilder.OdysseyGenerator.Run(ILogger logger, CommandLineArgs configuration) file C:\CW1\Shared\CargoWise.Model\src\DatabaseBuilder\DatabaseBuilder\Generator\OdysseyGenerator.cs:line 41
   location: CargoWise.Glow.Model.DatabaseBuilder.Program.Main(String[] args) file C:\CW1\Shared\CargoWise.Model\src\DatabaseBuilder\DatabaseBuilder\Program.cs:line 37

Elapsed Time: 44.988
Build step exited with result -532462766.

How can I solve the above problem?

I tried updating the VS version but it didn't help.

It looks like your application requires a different version of SQL than you have installed. Have you checked this: https://stackoverflow.com/questions/22256026/could-not-load-file-or-assembly-microsoft-sqlserver-sqlclrprovider-on-production — b166er, Feb 02 '23 at 05:55

Could not load file or assembly Microsoft.SqlServer.Types

0 Answers0