Friday, March 31, 2017

Quick Fix : There is no system code page on your computer that matches the code page of the collation for the database.

If you are still using a old version of Dynamics NAV or if you are trying to upgrade old version to a newer version of Dynamics NAV, then you might have a chance of getting below error message when you open up the database from Classic Client. 
---------------------------Microsoft Dynamics NAV Classic---------------------------
There is no system code page on your computer that matches the 850 code page of the SQL_Latin1_General_CP850_CI_AS collation for the XXXXXXXXXXXXXXXX database.
Your system code pages are: ANSI: 1252, OEM: 437.
Ensure that the Regional Options of the computer use the correct system language and locale for the code pages to match.
You can also disable the 'Validate Collation' setting for this database. It is possible that certain text data will not be converted correctly when stored in the database.
Click OK to disable the 'Validate Collation' setting and continue to use the database, or click Cancel to exit.
---------------------------OK Cancel ---------------------------
This error us due to your DB collations is different from your computer collation. You can have a quick fix to resolve this error however you might need to talk to your system and DB admin for a permanent solution. 

Quick Fix:

You need to change registry value in your computer to required Code page. In order to do that,

1. Press Start + R : To open Run Window
2. Enter "regedit" and click OK to open "Registry Editor"
3. Navigate to below path and find the OEMCP
4. Double click on the OEMCP and change Value Data to 850.


 [HKEY_LOCAL_MACHINE \SYSTEM \CurrentControlSet \Control \Nls \Codepage] OEMCP = "850" (Default = 437)  

5. Restart Your computer to update registries. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

No comments:

Post a Comment