Kbase 20472: SQL: How to enable ODBC tracing on Windows?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/3/2009 |
|
Status: Verified
GOAL:
SQL: How to enable ODBC tracing on Windows?
GOAL:
How to generate an ODBC trace file on Windows?
GOAL:
How to turn on ODBC tracing on Windows?
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
1. Select: Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
2. Select: the 'Tracing' tab from from the 'ODBC Data Source Administrator' dialog.
3. Enter: The trace log file or accept the default if any.
4) Click on 'Start Tracing Now'.
5) Click 'OK'
These steps start the trace and log entries in the file you specified. After you finish the query, come back to Tracing again and click on 'Stop Tracing Now'.
NOTE: Make sure you delete previous log file each time you run a new query otherwise the log file is appended and a huge file can be created.
The steps above will result in a log file which has a sequence of ODBC calls and error messages. Please take a look at the ODBC API Reference on how to read the log file (see URL below).