OptTrace (database connections) Purpose Returns or specifies an integer value indicating whether the ODBC Driver Manager performs tracing. If the trace file already exists, the ODBC Driver Manager appends to the file. If the trace file doesn't exist, the ODBC Driver Manager creates the file. If no tracing file has been specified, the ODBC Driver Manager writes to the file \SQL.LOG. Syntax DBConnection.OptTrace [= Constant] Constant Possible values: SQL_OPT_TRACE_OFF Tracing off. This is the default. SQL_OPT_TRACE_ON Tracing on. SQL_OPT_TRACE_DEFAULT Tracing off.