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