Patrick, Have you tried enabling log4net internal debug so that you can get a trace of any errors that may be occurring when connecting to the database? See: http://logging.apache.org/log4net/release/manual/faq.html#internalDebug
Cheers, Nicko > -----Original Message----- > From: Patrick [mailto:[EMAIL PROTECTED] > Sent: 29 November 2004 15:54 > To: 'Log4NET User' > Subject: ADONetAppender > > Dear Mr. Cadell! > > I want to use the DataAppender of log4net to save > log-information in a Database of my Smart Device Application. > > My dataTable looks as follows: > > Date nvarchar 50 > UserName nvarchar 50 > ClassName nvarchar 50 > Method nvarchar 50 > Description nvarchar 50 > Parameters nvarchar 200 > rowguid uniqueidentifier 16 > > My app.config file looks as follows: > > > <?xml version="1.0" encoding="utf-8" ?> > > <!-- .NET application configuration file > > The .NET Compact Framework does not support application > configuration files, > but log4net supports using configuration files with > similar names and structure, > to store the log4net configuration. > --> > > <configuration> > <configSections> > <section name="log4net" > type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/> > </configSections> > <log4net> > > <appender name="ADONetAppender_SqlServer" > type="log4net.Appender.ADONetAppender" > > <param name="ConnectionType" > value="System.Data.SqlClient.SqlConnection, System.Data, > Version=1.0.3300.0, > > Culture=neutral, PublicKeyToken=b77a5c561934e089" /> > <param name="ConnectionString" > value="workstation id=ACHATSCHITZ;packet size=4096;user > id=sa;pwd=sa;data source=achatschitz;persist security > info=False;initial catalog=HelpDesk" /> <commandText > value="INSERT INTO Instrumentation > ([Date],[UserName],[ClassName],[Method],[Description],[Paramet > ers]) VALUES > (@log_date, @thread, @log_level, @logger, @message, > @exception)" /> > <parameter> > <parameterName value="@log_date" /> > <dbType value="DateTime" /> > <layout type="log4net.Layout.RawTimeStampLayout" /> > </parameter> > <parameter> > <parameterName value="@thread" /> > <dbType value="String" /> > <size value="50" /> > <layout type="log4net.Layout.PatternLayout"> > <conversionPattern value="%t" /> > </layout> > </parameter> > <parameter> > <parameterName value="@log_level" /> > <dbType value="String" /> > <size value="50" /> > <layout type="log4net.Layout.PatternLayout"> > <conversionPattern value="%p" /> > </layout> > </parameter> > <parameter> > <parameterName value="@logger" /> > <dbType value="String" /> > <size value="50" /> > <layout type="log4net.Layout.PatternLayout"> > <conversionPattern value="%c" /> > </layout> > </parameter> > <parameter> > <parameterName value="@message" /> > <dbType value="String" /> > <size value="50" /> > <layout type="log4net.Layout.PatternLayout"> > <conversionPattern value="%m" /> > </layout> > </parameter> > <parameter> > <parameterName value="@exception" /> > <dbType value="String" /> > <size value="200" /> > <layout type="log4net.Layout.ExceptionLayout" /> > </parameter> > </appender> > <root> > <level value="DEBUG" /> > <appender-ref ref="ADONetAppender" /> > </root> > > </log4net> > > </configuration> > > And in my application I wrote the following code: > > protected static readonly ILog log = > LogManager.GetLogger(typeof(Login)); > log4net.Config.DOMConfigurator.Configure(); > > and in the method where I want to log information I add the following: > > log.Debug("The program got here!"); > LogManager.Shutdown(); > > But when I execute my application and invoke this method, > nothing happens. > Can you please help me what went wrong here? > > Best Regards > > -------------------------- > Patrick Achatschitz, Bakk. > Fasangasse 8/3 > 1030 Vienna > Austria > > Mobile: 01 650 270 8819 > > -----Urspr�ngliche Nachricht----- > Von: Nicko Cadell [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 29. November 2004 16:48 > An: Log4NET User > Betreff: RE: RollingFileAppender does not log to the file > > Marco, > > The debug output looks like everything is working as it should. > Can you confirm that the output file > "C:\Inetpub\wwwroot\amt\log\AMTLogger.log" is being created, > and is empty. > > Also I was wondering where the "2004-11-26 10:33:11,527 [2112] > test.Application_Start() - Test aus Application_Start" > message cam from, it looks like it is output through the > A_Console appender, however I don't think that the ASP.NET > service should have a Console attached (unless you are > hosting ASP.NET in your own Console App). > > What is the configuration file you are using? > > Cheers, > Nicko > > > -----Original Message----- > > From: Marco Herrn [mailto:[EMAIL PROTECTED] > > Sent: 26 November 2004 15:40 > > To: [email protected] > > Subject: RollingFileAppender does not log to the file > > > > Hi, > > > > I have a problem with using log4net in an ASP.NET application. The > > debug output of log4net says that it loads the log4net config file > > correctly and also opens the log file for reading. But nothing is > > written to the file. The debug output is appended to this mail. > > Any ideas what can be the problem here? > > > > Regards > > Marco > > > >
