Microsoft KB Archive/179261

= UA: Error Importing Log Files with Character Strings >255 Characters =

Article ID: 179261

Article Last Modified on 2/20/2004

-

APPLIES TO


 * Microsoft Site Server 2.0 Standard Edition, when used with:
 * Microsoft Usage Analyst

-



This article was previously published under Q179261



SYMPTOMS
When you are importing NCSA combined log format files, the following error message may appear and the import of subsequent records stops:

Error 50002 3700 Microsoft [ODBC SQL Server][SQL Server] Implicit conversion from datatype text to char is not allowed. Use the CONVERT function to run this query.



CAUSE
SQL Server calls anything > 255 chars as type text and not char. This causes the error above, because text type is handed differently than char types.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Site Server version 2.0.

This problem has been corrected in the latest U.S. Service Pack for Microsoft Site Server version 2.0. For information on obtaining the Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

Keywords: kbbug kbfix kbqfe KB179261

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.