Kbase P165333: Can you make use of multiple odbcini files on a single UNIX install to allow odbc tracing for a spec
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/05/2010 |
|
Status: Unverified
GOAL:
Can you make use of multiple odbc.ini files on a single UNIX install to allow ODBC tracing for a specific DSN?
GOAL:
How to turn on ODBC tracing on UNIX for only a specific client
FACT(s) (Environment):
UNIX
Progress/OpenEdge Product Family
FIX:
Yes, you can set up ODBC tracing for an individual client using a specific DSN in the following way:
1. Make a copy of the current $DLC/odbc/odbc.ini file to a different directory
2. Modify the copy of odbc.ini file by setting the Trace option value under the ODBC section to 1:
[ODBC]
InstallDir=/usr1/dlc/odbc
Trace=1
TraceFile=odbctrace.out
TraceDll=/usr1/dlc/odbc/lib/odbctrac.so
UseCursorLib=0
3. Set the ODBCINI environmental variable to point to the modified copy of the odbc.ini file used for the specific client either via command line, a script or by making use of the client's .profile:
ODBCINI=<path to modified file/odbc.ini>;export ODBCINI