Relevant

A New Template for Joomla!

 

Microsoft Retail Management System and Windows XP SP3

Microsoft advised Retail Management System (RMS) customers not to install Service Pack 3 for Windows XP. The issue has been fixed in KB952287, as pointed out to me by Jeff Hobbs on the RMS partner newsgroup (thanks mate!):

"As long as KB 952287, included in the August 12th Critical Windows Update installed properly, you're good to go.

If RMS is installed already and SP3 is being offered via Windows Update, then the KB has been installed. If you are doing it from a downloaded SP3 file, check the Windows Updates list first and see if the KB is listed around 08/12/08.

If you've already installed SP3 and are installing RMS, check the Windows Update list to see if its been installed, otherwise search for and install the KB."

My understanding is that a new version of MDAC (2.8) was supplied with Windows XP SP3 and Windows Vista SP1 (which I assume had the same problem), see the following section of the KB article:

MORE INFORMATION

This problem affects you if you use Retail Management System (RMS) Store Operations or Headquarters in Microsoft Dynamics on the Windows operating systems that are affected and that are supported. We recommend that you apply this hotfix to prevent invalid data or data loss.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

940569 (http://support.microsoft.com/kb/940569/) On a computer that has Microsoft Data Access Components 2.8 installed, an application receives an incorrect value for the identity column from a SQL Server 2005 database