You can enable the Oracle8 ODBC Driver to identify problems with applications.
When logging is enabled, log files are written to the application program's
current working directory. Note that log files can be quite large and can slow
down performance. Therefore, enable logging only when necessary, and disable it
when it is no longer needed.
The Oracle8 ODBC Driver installation procedure creates the following section
in the oraodbc.ini file:
[Oracle ODBC Driver Common]
Driver Logging=0
RemoveControlChars=NO
LockTimeOut=0
A value of 0 for logging indicates that Oracle8 ODBC Driver logging is turned
off.
To enable Oracle8 ODBC Driver logging, insert a valid Oracle8 ODBC Driver
logging value plus 1 after the equal sign, as shown in the following example:
[Oracle ODBC Driver Common]
Driver Logging=7
Valid Oracle8 ODBC Driver logging values are shown in the Driver Logging
Values table. To enable more than one type of logging, add the logging values and
then add 1, as shown in the Driver Logging Values table. For example, to log ODBC
entry points (a value of 2) and main functions (a value of 4), insert a value
of 7 (2 + 4 + 1) after the equal sign.
The driver log is written to the file oraodbc.log in the application program's
current working directory.
Driver Logging Values
Value
Value + 1
Description
0
-
Disable logging
2
3
Log ODBC entry points
Log main functions
Log ODBC entry points and main functions
Log ODBC utility functions
Log ODBC entry points and utility functions
Log ODBC main functions and utility functions
Log ODBC entry points, main functions, and utility functions
Log only SQL statements and errors
A value of 17 is usually the best Oracle8 ODBC Driver logging value to start
with initially for problem solving because it produces a small amount of output
and only logs the SQL statements sent to the server and any errors that are
returned from the server. This logging value will generally record 90% of the
errors that applications encounter.
Bookmark
Driver Logging
