Collecting an ODBC Trace (SQL.LOG)

Steps for collecting IBM i Access ODBC API calls

Follow these steps to collect an SQL.LOG:
  1. Start ODBC Data Source Administrator.
  2. Select the Tracing tab
  3. Select the Start Tracing Now button.
  4. Select Apply or OK.
  5. Recreate the error
  6. Return to ODBC Administrator.
  7. Select the Tracing tab.
  8. Select the Stop Tracing Now button.
  9. The trace can be viewed in the location that you initially specified in the Log file Path box.
Note: This procedure applies when you are using MDAC version 2.5. If you are using a different version of MDAC, then you may need to follow different steps.