jwcolby
jwcolby at colbyconsulting.com
Sun Jul 25 22:11:52 CDT 2010
Is anyone doing this? I am using the following as a config:
<target name="base" xsi:type="Database" keepConnection="true" useTransactions="true"
dbProvider="sqlserver" connectionString="Data Source=Azul;Initial
Catalog=_NLogDatabase;Integrated Security=True;">
<commandText>
INSERT INTO LogTable(time_stamp, [level], logger, [message]) VALUES
(@time_stamp, at level, at logger, at message)
</commandText>
<parameter name="@time_stamp" layout="${date:format=yyyy\-dd\-MM HH\:mm\:ss}"/>
<parameter name="@level" layout="${level}"/>
<parameter name="@logger" layout="${logger}"/>
<parameter name="@message" layout="${message}"/>
</target>
I have a server Azul, I am using integrated security, I created a database _NLogDatabase and a table
NLog with fields of those names.
Data types:
Time_Stamp: DateTime
Level: Varchar(50)
Logger: VarChar(50)
Message: Varchar(max)
So far the logs are going to file but not to the table.
--
John W. Colby
www.ColbyConsulting.com