Hello,
I'm trying to use a database target. But nothing is inserted in my database. So, I turned on nlog logging as said in the documentation. The result is :
2007-10-29 16:30:09.6835 Info NLog internal logger initialized.
2007-10-29 16:30:09.6835 Info Configuring from an XML element in ...
2007-10-29 16:30:09.7460 Info Adding target database:DatabaseTarget
2007-10-29 16:30:09.8241 Error Target exception: System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.
à NLog.Targets.DatabaseTarget.OpenConnection(LogEventInfo logEvent)
à NLog.Targets.DatabaseTarget.Write(LogEventInfo logEvent)
à NLog.LoggerImpl.Write(Type loggerType, TargetWithFilterChain targets, LogEventInfo logEvent, LogFactory factory)
My app.config contains :
<nlog>
<targets>
<target name="database" type="Database" connectionString="Data Source=***;Initial Catalog=***;Persist Security Info=True;User ID=***;Password=***">
<dbprovider>
sqlserver
</dbprovider>
<commandText>
insert into NLOG(TIMESTAMP,LEVEL,LOGGER,MESSAGE) values(@time_stamp, @level, @logger, @message);
</commandText>
<parameter name="@time_stamp" layout="${date}"/>
<parameter name="@level" layout="${level}"/>
<parameter name="@logger" layout="${logger}"/>
<parameter name="@message" layout="${message}"/>
</target>
</targets>
<rules>
<logger name="*" minlevel="Trace" appendTo="database"/>
</rules>
</nlog>
please, help...
Loic
