David rouillon wrote:
Nicko,
A tried the MySQL connector first with this appender:
<appender name="ADONetAppender_MySqlServer"
type="log4net.Appender.ADONetAppender" >
<bufferSize value="1" />
<param name="ConnectionType"
value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data" />
<param name="ConnectionString"
value="database=log4net;server=localhost;user id=user;password=userpass"
/>
<param name="CommandText" value="INSERT INTO log
(Date,Thread,Level,Logger,Message) VALUES (@log_date, @thread,
@log_level, @logger, @message)" />
MySQL doesn't use the @variable form any more - try ?variable instead
<param name="Parameter">
<param name="ParameterName" value="@log_date" />
Also, I think you might have to use log_date rather than @log_date
<param name="DbType" value="DateTime" />
<param name="Layout"
type="log4net.Layout.PatternLayout">
<param name="ConversionPattern"
value="%d{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" />
</param>
</param>
<param name="Parameter">
<....
You can also use "old syntax=yes" in your connection string to keep the
"old" behaviour.
--
Regards
David
David Anderson mailto: <[EMAIL PROTECTED]>
DMA Associates
t: 023 80273769
f: 0870 131 9143
m: 07966 889246
