Hello, We are running Navision on SQL Server2000. From the properties of my database I learn that the collation name is SQL_Latin1_General_CP850_CS_AS. We can access the database from all our clients without any problem, clients OS are Win95, Win98 and WinXP. I have installed a client on OS Win2000 but that client will not connect to the database and gives the following message ‘your current ANSI or OEM code page table on your computer does not match the code page 850 of the sorting SQL_Latin1_General_CP850_CS_AS for database xxxx’. In regional options of the Win2000 machine I tried almost every language setting for the system, but so far no setting allows me to access the database. Is there a solution for this problem known by one of the readers of the forum. Thanks in advance. Gerrit Zanen
I have encountered a similar codepage error message on SQL server 2000. If you’re running Navision Financials make sure you’re at least on version 2.60D(the executables). Futhermore in the regional settings the language corresponding to codepage 850 should be chosen and should be set as default. I hope this will help [:)]
Hi Gerrit, Changing regional settings won’t help. You need to edit your Windows 2000 client registry.(Start–>Run–>Regedit). The setting is available in HKEY_LOCAL_MACHINE under ‘nls’ some other place. It should be set to match the Codepage setting of your Server. Take care in backing up data/registry before making the change as sometimes, your OS may crash. Check your Networking Staff for help. Regards[8D]
The editing of Registry should generally not be necessary except in a few cases on old Win 9x machines. Just make sure that the “system” locale of your machine is identical or compatible with the SQL Server’s collation settings. - Jens
quote:
Originally posted by Jens Rainer
The editing of Registry should generally not be necessary except in a few cases on old Win 9x machines. Just make sure that the “system” locale of your machine is identical or compatible with the SQL Server’s collation settings. - Jens
Indeed it was not necessary to edit the registry. I have changed the default location to Dutch and from that moment it works fine. Thanks for all the good thinking. Gerrit