Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 321263 - Last Review: March 12, 2004 - Revision: 3.1
Web Server Log Import Is Unsuccessful When Code Page 850 Is Used in SQL Server
This article was previously published under Q321263
The Web server log import DTS task does not run on a
scheduled basis but runs manually when the Microsoft SQL Server code page is
850 instead of 1252.
SQL Server 2000 supports code page mapping. However, when
the Commerce 2000 configuration uses code page 850 for the DTS task, the code
page setting is obtained from the computer that is running SQL Server. A
mapping issue exists if SQL Server and Microsoft Windows 2000 are not both
configured with matching code pages. This occurs because Commerce Server 2000
uses American National Standards Institute (ANSI) data instead of Unicode data.
Modify the Windows 2000 code page to match the code page
that is configured for the computer that is running SQL Server.
To
work around this problem, configure the Windows 2000 code page for the Commerce
Server to match the code page that is configured for the computer that is
running SQL Server.
Because Commerce Server 2002 does not use any text data and
is fully Unicode-based, this problem does not occur in Commerce Server 2002.
You can successfully run the DTS task for Web log import
manually by using SQL Enterprise Manager. This application relies on the
default code page of the computer that is running SQL Server and does not use
the system code page. As a result, the SQL OLEDB Provider does not try to
perform Original Equipment Manufacturer (OEM) to ANSI code page translation.
For additional information, click the article
number below to view the article in the Microsoft Knowledge Base:
177561Â
(http://kbalertz.com/Feedback.aspx?kbNumber=177561/EN-US/
)
HOW TO: Add and Enable Additional Languages in Windows
APPLIES TO
- Microsoft Commerce Server 2000 Service Pack 2
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please