StarQuest Technical Documents

How to Generate an ODBC Trace with the ODBC Data Source Administrator

Last Update: 26 June 2008
Product: StarSQL, StarQuest Data Replicator
Version: All
Article ID: SQV00SQ018

Abstract

This document explains how to generate an ODBC API Trace from the ODBC Data Source Administrator. ODBC API traces are useful to StarQuest Technical Support for isolating problems.

Solution

Shut down the application (or service) before enabling the ODBC trace.

1. Launch the ODBC Data Source Administrator by going to Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

2. Select the Tracing tab.

3. Edit the Log File Path and provide a complete path to a new file (e.g. C:\ODBC_Trace.log).

4. Check the box "Machine-Wide tracing for all user identities" if it exists.

5. Click the Start Tracing Now button. Click OK to close the ODBC Data Source Administrator.

6. Restart the application and reproduce the problem or error message that you wish to capture in the ODBC trace.

7. After reproducing the problem, reopen the ODBC Data Source Administrator.

8. Select the Tracing tab, click the Stop Tracing Now button.

9. Locate the trace file. Compress the file before sending to StarQuest Technical Support.

DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.