Configuring a Windows application for tracing

Enabling tracing on the TableViewer sample application involves creating a configuration file that references the ConsoleTraceListener and TextWriterTraceListener listeners, removes the default listener, and enables all switches that would otherwise be set to 0.

Prerequisites

You must have Visual Studio installed.

Context and remarks

Windows Mobile does not support tracing.

 Task

  1. Open the TableViewer sample in Visual Studio.

    Start Visual Studio and open the %SQLANYSAMP12%\SQLAnywhere\ADO.NET\TableViewer\TableViewer.sln.

  2. Create an application file named App.config and copy the following configuration setup: 



    <?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.diagnostics>
<sources>
 <source name="iAnywhere.Data.SQLAnywhere" 
         switchName="SASourceSwitch" 
         switchType="System.Diagnostics.SourceSwitch">
  <listeners>
   <add name="ConsoleListener" 
        type="System.Diagnostics.ConsoleTraceListener"/>
   <add name="TraceLogListener" 
        type="System.Diagnostics.TextWriterTraceListener" 
        initializeData="myTrace.log" 
        traceOutputOptions="ProcessId, ThreadId, Timestamp"/>
   <remove name="Default"/>
  </listeners>
 </source>
</sources>
<switches>
 <add name="SASourceSwitch" value="All"/>
 <add name="SATraceAllSwitch" value="1" />
 <add name="SATraceExceptionSwitch" value="1" />
 <add name="SATraceFunctionSwitch" value="1" />
 <add name="SATracePoolingSwitch" value="1" />
 <add name="SATracePropertySwitch" value="1" />
</switches>
</system.diagnostics>
</configuration>

  3. Rebuild the application.

  4. Click Debug » Start Debugging.

Results

When the application finishes execution, the trace output is recorded in the bin\Debug\myTrace.log file.

Next

View the trace log in the Output window of Visual Studio.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1