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 —————————
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,
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?
Works perfect. Many Thanks