OpenLink ADO.Net Provider Call Tracing

To enable tracing using any of the the OpenLink ADO.Net Providers, create an environment variable called OPL.NET.TRACE.CONFIG, for example on Windows:

        set OPL.NET.TRACE.CONFIG=C:\Program Files\OpenLink Software\UDA\adotrace.cfg

This file will contain suitably marked up structured XML as described below, with the key elements of the tracefile being:

  tracelevel ::= None | Exception | Warning | Info | Call | InternalCall | Debug

     If tracelevel is omitted, the trace level defaults to None

  tracefile  ::= filename prefix for tracefile

     If tracefile is omitted, trace output is directed to the console

The actual name of the generated tracefile takes the form:

   <filename prefix>_<application domain name>_<process id>_<application domain id>_<provider name>.log

      The filename prefix can include an absolute path or a relative path  

Trace output written to the specified log file would take the form:

  <time> [<thread id>:<stack depth>] <object name>.<method>: <context>

     where context can be:

       ENTRY           - method entry
       EXIT              - method exit
       EXCEPTION   - exception thrown
       MESSAGE      - general trace message

A thread's exit from a method is not shown unless the method has a non-void return type or output parameters (e.g. ref or out parameters in C#). When not shown, the method will have exited before the first subsequent entry in the trace output where the thread's stack depth is less than its stack depth when the method was entered.

A sample trace file content to trace calls from each of the support OpenLink ADO.Net Providers would be of the form:

<providers>

  <provider name="OpenLink.Data.OdbcClient">
    <tracelevel>
        Debug
    </tracelevel>
    <tracefile>
        c:\trace_odbc
    </tracefile>
  </provider>

  <provider name="OpenLink.Data.SQLServer">
    <tracelevel>
        Debug
    </tracelevel>
    <tracefile>
        c:\trace_sql
    </tracefile>
  </provider>

  <provider name="OpenLink.Data.Sybase">
    <tracelevel>
        Debug
    </tracelevel>
    <tracefile>
        c:\trace_syb
    </tracefile>
  </provider>

  <provider name="OpenLink.Data.GenericClient">
    <tracelevel>
        Debug
    </tracelevel>
    <tracefile>
        c:\trace_generic
    </tracefile>
  </provider>

</providers>