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.

1. Open the TableViewer sample in Visual Studio.

   Start Visual Studio and open the %ALLUSERSPROFILE%\SybaseIQ\samples\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.

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