Kbase P5815: How to turn on ODBC tracing on UNIX?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to turn on ODBC tracing on UNIX?
GOAL:
How to generate an ODBC trace file on UNIX?
GOAL:
How to enable ODBC Tracing on UNIX
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
UNIX
FIX:
Usually, ODBC drivers on windows are used to connect an ODBC application on windows to a local or remote database. But sometimes, an UNIX ODBC application such as PHP can use ODBC drivers on UNIX to connect to a local or remote database. Under such circumstances, ODBC tracing can be used in troubleshooting connection problems.
Following steps demonstrate how to set ODBC tracing on UNIX, it assumes you have at least client networking installed on UNIX which has ODBC driver for UNIX shipped with it.
Set the Trace option value under the ODBC section in the $DLC/odbc/odbc.ini file to 1 so that ODBC API calls are outputted to an ODBC trace log file, which is specified by the TraceFile option. Example:
[ODBC]
InstallDir=/usr1/dlc/odbc
Trace=1
TraceFile=odbctrace.out
TraceDll=/usr1/dlc/odbc/lib/odbctrac.so
UseCursorLib=0