With SQL Server 2012, the Web site was running ok with tables containing Spatial Data Type.
The only think I did was to install the following two files on the Web server:
Microsoft System CLR Types for Microsoft SQL Server System
Microsoft SQL Server Shared Management Objects
...and, adding this to the connection string: ;Type System Version=SQL Server 2012
Now, the Web site is running against SQL Server 2014. Then, of course, it no longer runs. We have this:
"DataReader.GetFieldType(371) returned null."
So, I upgraded the project to use the new 2014 version of the above two files. I had to remove that setting in the connection string as this is no longer supported.
But, the Web site does not want to run. This is the same error.
Some says to add a reference to Microsoft.SqlServer.Types.dll in the project and deploy that to the Web site bin directory. I did that with no success.
Some says to lower down the application pool to 32 bits. I did that with no success.
Is this still working in 2014?