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:MajorLast Reviewed:8/11/1999
Keywords:kbprb KB177707