RE: ODBC Trace no longer works since installing SP2 and MDAC

From: Anton Klimov [MS] (aklimov_at_online.microsoft.com)
Date: 02/21/05


Date: Mon, 21 Feb 2005 10:13:04 -0800

Make sure tracing is turned on before the application starts (tracing is in
part of odbc driver manager, it needs to be enabled before odbc32.dll is
loaded by the app that the customer wants to trace). The log location can be
changed as long as the app has the permission to write to the new location,
the default path is always user specific, so the log file is secure.
 
The “machine wide tracing” button is useful for tracing a windows service
which is running under a different user account than the current window logon
user, e.g. a service is running under domain\user_a, but you log on as user_b
to modify tracing option, the only way the service can see the tracing
setting modified by user_b is by user_b using the “machine wide tracing”
option.
-------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.