The odbc.ini file located under the Strategy installation directory contains information about all of the DSNs available for Strategy Intelligence Server Universal. In addition, it also contains an entry with general ODBC information and the parameters that control ODBC tracing (similar to the ODBC trace available on Windows systems) under the [ODBC] heading. Note that the file path for the trace library is dependent on the version of Strategy installed. This heading is prepopulated automatically in the odbc.ini file, and in most cases should not be modified except to change the output location for the odbctrace.out file or to enable and disable the trace.
Strategy 2021:
[ODBC]
Trace=0
TraceFile=<location>/odbctrace.out
TraceDll=<MSTR_INSTALL>/install/lib/MYtrcXX.so
InstallDir=<MSTR_INSTALL>
IANAAppCodePage=106
UseCursorLib=0
For some older versions of Strategy, the directory or the name of trace library was slightly different:
TraceDll=<MSTR_INSTALL>/install/lib32/MYtrcXX.so
or
TraceDll=<MSTR_INSTALL>/lib32/odbctrac.so
Example [ODBC] section (based on the default installation directories for a Strategy installation):
[ODBC]
Trace=0
TraceFile=/var/opt/MicroStrategy/odbctrace.out
TraceDll=/opt/MicroStrategy/lib/MYtrcXX.so
InstallDir=/opt/Strategy
IANAAppCodePage=106
UseCursorLib=0
The following is an explanation of the different options available under [ODBC]:
Note: The trace file odbctrace0x.out (like odbctrace01.out, odbctrace02.out, …) will generate if the trace file name is set to odbctrace.out in odbc.ini.
- Trace:
This option is used to enable/disable ODBC tracing. To enable tracing set Trace=1. To disable set Trace=0.
- TraceFile:
This option determines the name of the file where ODBC trace information will be written. By default, trace information is written to the odbctrace.out file. A location should be specified here as seen in the example above.
- TraceDll:
This option indicates which library to use to determine how to capture and log trace information.
- InstallDir:
This option refers to the Strategy directory containing the installation files.
- IANAAppCodePage:
This option determines which language/character set to use when communicating with the database. The default setting of 106, indicates that the UTF-8 character set will be used.
Refer to this article to configure ODBC DSN for International environments: KB10136: How to configure ODBC Data Source Names for international environments in MicroStrategy Intelligence Server Universal
- UseCursorLib:
This option determines whether or not the ODBC Manager cursor support overrides the ODBC driver support. To enable this option set UseCursorLib=1. To disable, set UseCursorLib=0.
