The ODBC Data Source Administrator in Windows has a feature called "Tracing", which allows for the logging of all ODBC calls to text file. Here is a screenshot of the dialog:
This log file will include each and every call made into the ODBC driver, with parameter values (including constants) as well as return codes. Here is an example of a call to the SQLSetStmtAttr function:
|4D 9a4-9a8 ENTER SQLSetStmtAttr |
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
This log can prove quite useful when debugging ODBC applications. To enable the log:
- Launch the ODBC Data Source Administrator.
- Click on the "Tracing" tab.
- Click the button labeled "Start Tracing Now".
Be sure to make note of the location of the log file. Also note that the log file can grow quite large so it is a good idea to delete it from time to time.