Last post Mar 15, 2012 10:54 AM by Cathy Mi - MSFT
Feb 16, 2012 03:49 PM|HappyWales|LINK
Ive been getting an error, I have an error with the entity framework. I have a SQL Server 2005 SP2.
When the ProviderManifestToken = "2008" I get this error.
The version of SQL Server in use does not support datatype 'datetime2'.
Ive done the change shown here and when chagned to "2005" I get
Schema specified is not valid. Errors: DatabaseAccess.Schema.Model1.ssdl(2,123) : error 0169: All SSDL artifacts musttarget the same provider. The ProviderManifestToken '2008' is different from '2005' that was encountered earlier.
I dont understand
My Database version is Microsoft SQL Server Standard Edition (64-bit) 9.00.3042.00
Ive tried deleting the schema and re adding it to no avail. Restarting etc
Ive alse made all my date time fields nullable
Please help :)
Feb 18, 2012 01:48 AM|Decker Dong - MSFT|LINK
Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything
Now you can refer this for more：http://stackoverflow.com/questions/316422/using-sql-server-2008-and-sql-server-2005-and-date-time
Feb 18, 2012 05:12 AM|HappyWales|LINK
I have done this,
however i still get the error message
Schema specified is not valid. Errors: DatabaseAccess.Schema.Model1.ssdl(2,123) : error 0169: All SSDL artifacts must target the same provider. The ProviderManifestToken '2008' is different from '2005' that was encountered earlier.
Feb 18, 2012 08:21 PM|Decker Dong - MSFT|LINK
Which kind of SQL Server are you using？SQL2005 or SQL2008？
Feb 19, 2012 07:59 AM|HappyWales|LINK
Feb 21, 2012 03:27 PM|Cathy Mi - MSFT|LINK
Do you happen to have more than one EDMX file in the project? Make sure to make the change in all of them, if necessary.
Feb 21, 2012 04:33 PM|HappyWales|LINK
no there is only 1 file..
I dont know what im doing wrong :(
Mar 15, 2012 10:54 AM|Cathy Mi - MSFT|LINK
Did you find the problem? If not, could you do a Search (Find) in the entire solution for the "ProviderManifestToken" string to see where else it may be set?