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:
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):
Keywords: kbbug kbfix kbqfe KB179261