Microsoft KB Archive/249222

= Importing Proxy Log File in an Access Database May Fail if Log File Contains a Pipe Character =

Article ID: 249222

Article Last Modified on 9/23/2005

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q249222



SYMPTOMS
When you import a log file with log entries that contain query strings with a Pipe Character ("|"), Usage Import quits and displays the following error message:

Error Querying the Import Job.

Error 3077: DAO.Recordset Syntax error in string in expression.

This problem only occurs when using the Usage Analysis Version for use with an Access Databases.



CAUSE
The presence of the Pipe character in a query string causes Uas.exe to quit because the Jet Engine uses this character as a field delimiter in SQL statements.



RESOLUTION
To resolve this problem, obtain the latest service pack for Site Server version 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

219292 How to Obtain the Latest Site Server 3.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Site Server 3.0. This problem was first corrected in Site Server 3.0 Service Pack 4.



MORE INFORMATION
For additional information, see the following article or articles in the Microsoft Knowledge Base:

147687 HOWTO: Query for Literal Special Characters in a Where Clause

178070 HOWTO: Handle Quotes and Pipes in Concatenated SQL Literals

Keywords: kbbug kbfix kbqfe kbsiteserv300sp4fix kbhotfixserver KB249222

-

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

© Microsoft Corporation. All rights reserved.