After running an ASP.NET C# application with SQL SERVER version 2012, I get the following error message:
An error occurred during local report processing. The definition of the report 'C:\inetpub\wwwroot\psla\Reports\PD Listing Report - Per ED.rdlc' is invalid. An unexpected error occurred in Report Processing. Could not load file or assembly 'Microsoft.SqlServer.Types, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
What could be the cause? I have tried searching the net and there are references to version=188.8.131.52 but there are no references to version=184.108.40.206 for 'Microsoft.SqlServer.Types'. Reviewing the reference Manager for visual studio 2015, I was only able to find up to version=220.127.116.11.
In your Package Manager download the 12 version from Nuget
Also see that entry for this is backward compatible in web.config
In your references folder right click and set copy local = true
It appears that some library in your project is referencing Microsoft.SqlServer.Types, Version=18.104.22.168 but .NET runtime cannot find it at execution.
On the web server, where the application is running, make sure that there exists a following directory:
Also make sure that this directory has the file
Microsoft.SqlServer.Types.dll of version 12 (12.0.2000.8). Different versions of the file can be downloaded from https://www.nuget.org/packages/Microsoft.SqlServer.Types/
User contributions licensed under CC BY-SA 3.0