Microsoft KB Archive/235129

= Site Server Usage Analysis Report Writer Fails Against Web Farm Log Source with SQL 6.5 =

Article ID: 235129

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q235129



SYMPTOMS
Errors occur with report writer when working in a Web farm environment using multiple log datasources. Errors only occur when reporting against a Microsoft SQL 6.5 database. If reporting is performed against an Access database, it functions correctly.



CAUSE
When reporting against a SQL database, values in SQL "where" clauses are not single quoted. This causes SQL to issue an error and quit the report.



RESOLUTION
To resolve this problem, obtain the latest service pack for Site Server 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



WORKAROUND
To workaround this problem, report against Access database instead of SQL Server.



STATUS
This problem was first corrected in Site Server 3.0 Service Pack 3.

Keywords: kbbug kbfix kbqfe KB235129

-

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

© Microsoft Corporation. All rights reserved.