ODBC Logging Fails Without Warning (177707)
The information in this article applies to:
- Microsoft Proxy Server 2.0
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)
Modification Type: | Major | Last Reviewed: | 8/11/1999 |
---|
Keywords: | kbprb KB177707 |
---|
|