Skip to main content

From the Microsoft Dynamics NAV Blogs: Upgrade database error; New item categories; Embed NAV in SharePoint; Restart a ‘frozen’ job

by Linda Rosencrance
Contributing Writer, MSDW

From this week's Microsoft Dynamics NAV blogs:

  • Quick Fix: There Is no System Code Page on Your Computer that Matches the Code Page of the Collation for the Database
  • The New Item Categories Feature Replaced the Product Group Feature in Dynamics NAV 2017
  • Embedding Microsoft Dynamics NAV and Its Web Parts in SharePoint Online
  • How to Restart a Job in ‘Error' or ‘Frozen Completed' Status

Quick Fix: There Is no System Code Page on Your Computer that Matches the Code Page of the Collation for the Database

On his TharangaC - Dynamics NAV Blog, Tharanga Chandrasekara wrote that people who are still using an old version of Microsoft Dynamics NAV, or are trying to a newer version, might see the following error message when they open up the database from the 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 ---------------------------

You received this error message because your database collations are different from your computer collation, he said. You can have a quick ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Linda Rosencrance

Linda Rosencrance is a freelance writer/editor in the Boston area. Rosencrance has over 25 years experience as an reporter/investigative reporter, writing for many newspapers in the metropolitan Boston area. Rosencrance has been writing about information technology for the past 16 years.

She has covered a variety of IT subjects, including Microsoft Dynamics, mobile security issues such as data loss prevention, network management, secure mobile app development, privacy, cloud computing, BI, big data, analytics, HR, CRM, ERP, and enterprise IT.

Rosencrance is the author of six true crime books for Kensington Publishing Corp.