Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Web site no longer run with Spatial Data Type
Message
De
16/06/2016 10:43:14
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Web site no longer run with Spatial Data Type
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:
01637427
Vues:
54
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?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform