Microsoft KB Archive/177707

= ODBC Logging Fails Without Warning =

Article ID: 177707

Article Last Modified on 8/11/1999

-

APPLIES TO


 * Microsoft Proxy Server 2.0 Standard Edition

-



This article was previously published under Q177707



SYMPTOMS
When you are configured to log to an ODBC datasource, your requests will fail to be logged without warning if the table name specified is incorrect.



CAUSE
If the table name is invalid, does not exist, or is not in the proper format, no logging will take place. The user will not be warned that the ODBC properties were incorrectly configured or that the table structure is incorrect.



RESOLUTION
Verify that the table name is specified correctly in the ODBC logging properties of Web or Winsock Proxy properties.

Also, ensure that the table structure is in the correct format. Proxy 2.0 Setup program provides a SQL Server script to create the table structure for Web Proxy, Winsock Proxy, and Packet Filter logging. They are located in the following directories:   Drive:\%Winnt%\Help\Proxy\Misc\Msp.sql (Web and Winsock logging)

Drive:\%Winnt%\Help\Proxy\Misc\Pf.sql (Packet Filter logging)

Additional query words: odbc logging proxy

Keywords: kbprb KB177707

-

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

© Microsoft Corporation. All rights reserved.