Can't restore backup on SQL server

mahesh · 2008-03-07

Im from india. Trying to restore the russian navision backup (came with CD) on SQL server but im failed with given below error.

Microsoft Business Solutions-Navision

The Payment Terms table contains a value in a Code field that cannot be used with Microsoft Business Solutions-Navision:

Field: Code
Value: ìÅ

main thing is when i tried same on local PC, it worked.
i also installed russian fonts. but then also why it is not possible on SQL server 2003?

plz guid.

Waldo · 2008-03-07

This is probably because of the codepage you used. Try to use the same codepage as the original DB.

garak · 2008-03-07

waldo's right. Check the codepage on SQL Server.
The Codepage on SQL Server and the used codepage on Database should be the same.

For you problem, xou have on the orig. Server for example Codepage with kurylix (rusian) but on the new Server Codepage 850 or Latian.

ara3n · 2008-03-07

If you have two companies, one in china and one in Korea, and they are going to be on the same sql box, will they need two different citrix boxes with different codepages? Can Korea and China be on same codepage?

mahesh · 2008-03-08

but on sql server, there are already 5 navision databse are there.
If i change codepage to russian then Will it affect other databases??

If Yes then how can i use two language DataBase on same sql server?

ara3n · 2008-03-08

you would be changing the codepage on the computer that is running finsql.exe not on the server.

mahesh · 2008-03-09

thanx ara3n,

as im completely novice with CODEPAGE.
so plz could u answer my another Ridiculous question?

Please tell me the steps to change codepage.
Ill be very thankful to u.
_________________
Cheers,
mahESH jain
www.intech-systems.com

kine · 2008-03-09

1) There are two things you need to set correctly:

a) Collation - it is property of the Database on the SQL server - you can find it in File-Database-Alter dialog. To be able to select another language than your cliet, you need to uncheck the "Check codepage" checkbox or start the client from PC configured to support the language (unchecking th checkbox can lead to character misstranslation and another problems...)

b) Codepage - because the finsql.exe is not unicode application, the "codepage" (which ASCII table will be used to show the data etc.) is driven by settings in "Control Panel - Local Settings - Language for non-unicode applications". This settings must be set to correct language to be able to work with the database.

ara3n · 2008-03-09

Kine, if you have two companies, Korean and chines in same db through citrix, would they need to have two citrix boxes with different codepages?

kine · 2008-03-10

I do not know, if you can change the codepage per user in citrix, it means that I must say "I do not know..." :-)

ara3n · 2008-03-10

It's per computer and effects all the users.

Can't restore backup on SQL server

Comments

Categories