How to enable ODBC debug trace logging for Windows?

How to enable ODBC debug trace logging for Windows?

book

Article ID: KB0071135

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported versions

Description

The purpose of this article is to explain how to enable ODBC debug trace logging on a Windows system, which will provide us with information related to fetch calls and any data being processed via trace files.

Issue/Introduction

This article outlines the steps to enable ODBC debug trace logging on a Windows system.

Environment

Windows Environment

Resolution

On the Windows machine, launch the "ODBC Data Source Administrator" and follow the steps below to enable ODBC trace logging:

(1) Navigate to the Tracing tab in the ODBC Data Source Administrator.
(2) Enter the name of the log file that the file will be saved as (eg: D:\tmp\foo.log)
(3) Select the check box that states "All users will benefit from machine-wide tracking"
(4) To start tracing, click "Start Tracing Now", then click "OK" or "Apply".
(5) Launch the client application and run tests.
(6) A trace file with the debug trace will be created at the location specified above.

User-added image
 

Additional Information

An example ODBC debug trace file is included in the attachments.

Attachments

How to enable ODBC debug trace logging for Windows? get_app