Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DataReader.GetFieldType(68) returned null
Message
De
11/08/2013 21:10:20
 
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01579975
Message ID:
01580278
Vues:
39
>Why don't you just set the database type on SQL 2012 to SQL 2008. Then everything that used to work will continue to work.
>
>I'm not convinced that the behavior you describe is actually failing. I run SQL 2012 locally and 2008 on my server and I can easily use spatial types in my database (as long as the DB is set to 2008 DB). I'm running .NET 4.5 and I'm running my apps in 32 bit mode.

If you are using .NET 4.5, it probably means you are using Windows Server 2008 OS for your Web Server. We are still at Windows Server 2003 so we cannot go higher than .NET 4.0. In trying to make things work last night, I found a few items which I was not able to try because of this restriction. Actually, the OS being close to 10 years difference of SQL Server 2012 is starting to make a difference.

About the switch you mentioned, is this a backward compatibility switch at the SQL Server level? If yes, what would be the advantages of running SQL Server 2012 if we ask it to run as it we would have installed SQL Server 2008?

Also, based on the timeframe I have, there is just no way to switch to a new environment without proper testing first. While it may seems simple to use a switch to resolve the issue, if in fact that would work for me, this would still require a lot of testing and we have decided to delay that transition for now. I would feel more comfortable when the Web servers would be on Windows Server 2008 or higher, in 64-bit environment. Then, we would have less possibilities of facing walls here and there.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform