Web Server Log Import Is Unsuccessful When Code Page 850 Is Used in SQL Server (321263)

SYMPTOMS

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.

CAUSE

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.

WORKAROUND

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.

STATUS

Because Commerce Server 2002 does not use any text data and is fully Unicode-based, this problem does not occur in Commerce Server 2002.

MORE INFORMATION

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 HOW TO: Add and Enable Additional Languages in Windows