Restoring database receives UNICODE error

Hi,
I am having problem while restoring database to another SQL Server. I
receives below given message. My both SQL Servers are 7.0.
MESSAGE
SQL DMO (ODBC SQL Stae 42000)
The database you are attmpting to restore was backup under a different unicode
Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
Locale ID
1033 or Unicode comparion style 196611) Currently running on this server.
Backup or restore Operation terminating abnormally.
Ok Button.
MESSAGE OVER
Anyone who can solve this problem.
Nilkanth Desai
I think that although the error message is from ODBC the issue is in the
tool you're using. Perhaps you would get a better response posting to a
group with knowledge of the tools you're using - or to the SQL Server team
in general.
| Thread-Topic: Restoring database receives UNICODE error
| thread-index: AcXKdpDDNRh+0thOR76Cjqm0RNXUxA==
| X-WBNR-Posting-Host: 61.1.58.32
| From: "=?Utf-8?B?Tmlsa2FudGggRGVzYWk=?="
<NilkanthDesai@.discussions.microsoft.com>
| Subject: Restoring database receives UNICODE error
| Date: Thu, 6 Oct 2005 06:05:03 -0700
| Lines: 23
| Message-ID: <D3F9E543-916B-44A7-ACD4-AD3200C10CA6@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2822
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hi,
| I am having problem while restoring database to another SQL Server.
I
| receives below given message. My both SQL Servers are 7.0.
|
| MESSAGE
| SQL DMO (ODBC SQL Stae 42000)
| The database you are attmpting to restore was backup under a different
unicode
| Locale ID (1033) or Unicode Comparision Style 196609) Then the Unicode
| Locale ID
| 1033 or Unicode comparion style 196611) Currently running on this server.
|
| Backup or restore Operation terminating abnormally.
|
| Ok Button.
|
|
| MESSAGE OVER
|
| Anyone who can solve this problem.
|
| Nilkanth Desai
|
|
|