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

ID: Q249222

The information in this article applies to:

Microsoft Site Server version 3.0

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

A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem. If you are not severely affected by this specific problem, Microsoft recommends that you wait for the next Site Server service pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information on support costs, please go to the following address on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

The English version of this fix should have the following file attributes or later:


   Date      Time    Version    Size      File name     Platform
   -------------------------------------------------------------
   07/02/98  08:27p                   913 eula.txt      ALPHA
   12/23/99  08:07p  7.0.1284.0 1,304,848 uas.exe       ALPHA
   01/27/99  07:56p                80,144 update.exe    ALPHA
   12/23/99  10:37p                 2,572 update.inf    ALPHA
   07/02/98  08:27p                   913 eula.txt      i386
   12/23/99  08:08p  7.0.1284.0   676,384 uas.exe       i386
   01/27/99  07:02p                62,544 update.exe    i386
   12/23/99  10:37p                 2,572 update.inf    i386

STATUS

Microsoft has confirmed this to be a problem in Site Server 3.0.

MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

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

Q178070 HOWTO: Handle Quotes and Pipes in Concatenated SQL Literals

Additional query words:

Keywords :
Version : winnt:3.0
Platform : winnt
Issue type : kbbug