Collecting an ODBC Trace (SQL.LOG)

Steps for collecting IBM® i Access ODBC API calls

About this task

Follow these steps to collect an SQL.LOG:

Procedure

Start ODBC Data Source Administrator.
Select the Tracing tab
Select the Start Tracing Now button.
Select Apply or OK.
Recreate the error
Return to ODBC Administrator.
Select the Tracing tab.
Select the Stop Tracing Now button.
The trace can be viewed in the location that you initially specified in the Log file Path box.

Results

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.