LogMessages Property (Remote Data)

       

Enables ODBC trace logging and returns or sets a value indicating the path of the ODBC trace file created by the ODBC driver manager to record all ODBC operations.

Syntax

object.LogMessages [= value]

The LogMessages property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A String expression as described in Settings.

Settings

Value contains the path of an ASCII file used to log ODBC operations. If the LogMessages property is an empty string, no logging takes place.

Remarks

When the LogMessages property is True, all ODBC commands are sent to an ASCII log file that can be used to debug or tune queries or other operations.

On Windows NT or Windows 95, tracing should only be used for a single application or each application should specify a different trace file. Otherwise, two or more applications might attempt to open the same trace file at the same time, causing an error.

Note   ODBC performance is adversely affected when the log is enabled.