Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Web site no longer run with Spatial Data Type
Message
 
 
À
16/06/2016 10:43:14
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01637427
Message ID:
01637428
Vues:
51
I suggest to ask your question here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlspatial



>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?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform