System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2

Question

I have just uploaded a new version of code to my server and got this error bug that i cannot understand and don't know how to solve - I had no changes with datetime2 - I don't even have this word in my code syntax. Do you know what that means?

An error occurred while executing the command definition. See the inner exception for details:

InnerException: System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2'.

at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior

Knowing nothing of ef, any chance you are calling add parameters with value without specifying data type? Name of method approximate — billinkc
– billinkc, Commented Dec 31, 2011 at 2:07
possible duplicate of Using SQL Server 2008 and SQL Server 2005 and date time — Paul Keister
– Paul Keister, Commented Mar 29, 2012 at 23:24

sth · Accepted Answer · 2012-01-08 15:06:41Z

7

It turns out that Entity Framework 4 somehow got the idea to use SQL Server 2008. The fix was to edit the .edmx file in an XML editor and set the ProviderManifestToken="2005" instead of 2008. (You need to rebuild.)

edited Jan 8, 2012 at 15:06

sth

231k56 gold badges288 silver badges370 bronze badges

answered Dec 31, 2011 at 8:53

Sveta26

5412 gold badges8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related