title: Does log4net AdoNetAppender support sql server 2008?
body: <p>My config file below: very strange,I have spent a day to find out where I am wrong, but still not working, it still not log anything in the database，but I can output them using RollingFileAppender. Also, the store procedure WriteLog is working well.(I have tested it using sql server studio). I have tried to change the connectionType but not working. 
  Unfortunately I don't have sql server 2000/2005 to test, my log4net version should be the latest one: log4net 1.2.10.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;configuration&gt;
    &lt;configSections&gt;
      &lt;section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" /&gt;
    &lt;/configSections&gt;
    &lt;log4net&gt;
        &lt;appender name="AdoNetAppender_SqlServer" type="log4net.Appender.AdoNetAppender"&gt;
          &lt;!--&lt;threshold value="OFF" /&gt;--&gt;
          &lt;bufferSize value="1" /&gt;
          &lt;connectionType value="System.Data.SqlClient.SqlConnection, System.Data, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
          &lt;!--&lt;connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;--&gt;
          &lt;connectionString value="Data Source=.\MSSQLSERVER2008,2222;Initial Catalog=UnleashedSaaS;User ID=sa;Password=dogblack;" /&gt;
          &lt;commandType value="StoredProcedure" /&gt;
          &lt;commandText value="WriteLog" /&gt;
          &lt;parameter&gt;
          &lt;parameterName value="@log_date" /&gt;
          &lt;dbType value="DateTime" /&gt;
          &lt;layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" /&gt;
              &lt;/parameter&gt;
        &lt;parameter&gt;
                  &lt;parameterName value="@thread" /&gt;
                  &lt;dbType value="String" /&gt;
                  &lt;size value="255" /&gt;
                  &lt;layout type="log4net.Layout.PatternLayout" value="%thread" /&gt;
              &lt;/parameter&gt;
        &lt;parameter&gt;
                  &lt;parameterName value="@log_level" /&gt;
                  &lt;dbType value="String" /&gt;
                  &lt;size value="50" /&gt;
                  &lt;layout type="log4net.Layout.PatternLayout" value="%level" /&gt;
              &lt;/parameter&gt;
        &lt;parameter&gt;
          &lt;parameterName value="@logger" /&gt;
                    &lt;dbType value="String" /&gt;
                    &lt;size value="255" /&gt;
                    &lt;layout type="log4net.Layout.PatternLayout" value="%logger" /&gt;
              &lt;/parameter&gt;
        &lt;parameter&gt;
                &lt;parameterName value="@message" /&gt;
                &lt;dbType value="String" /&gt;
                &lt;size value="4000" /&gt;
                &lt;layout type="log4net.Layout.PatternLayout" value="%message" /&gt;
              &lt;/parameter&gt;
           &lt;parameter&gt;
               &lt;parameterName value="@exception" /&gt;
               &lt;dbType value="String" /&gt;
               &lt;size value="4000" /&gt;
               &lt;layout type="log4net.Layout.ExceptionLayout" /&gt;
           &lt;/parameter&gt;
        &lt;/appender&gt;
        &lt;appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender" &gt;
          &lt;!--&lt;threshold value="OFF" /&gt;--&gt;
          &lt;file value="LogData\\" /&gt;
          &lt;appendToFile value="true" /&gt;
          &lt;datePattern value="ul_yyyy-MM-dd.LOG" /&gt;
          &lt;maxSizeRollBackups value="10" /&gt;
          &lt;rollingStyle value="Date" /&gt;
          &lt;maximumFileSize value="2MB" /&gt;
          &lt;staticLogFileName value="false" /&gt;
          &lt;layout type="log4net.Layout.PatternLayout"&gt;
            &lt;param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} %p %u %c %l %m %n%n%n" /&gt;
          &lt;/layout&gt;
        &lt;/appender&gt;
        &lt;root&gt;
          &lt;level value="ALL"/&gt;
          &lt;appender-ref ref="AdoNetAppender_SqlServer" /&gt;
          &lt;appender-ref ref="RollingLogFileAppender" /&gt;
        &lt;/root&gt;
      &lt;/log4net&gt;
  &lt;/configuration&gt;
  </code></pre>