Thanks for the many answers. It works with storing the encrypted password in the config file. So Problem solved.
Regards Bernhard > Subject: RE: How to pass password to AdoNetAppender? > Date: Wed, 22 Oct 2008 11:17:08 -0400 > From: [EMAIL PROTECTED] > To: [email protected] > > Store the encrypted information in a config file. Use a setup program > to solicit and encrypt the information. Use the DPAPI wrapper code > (System.Security.Cryptography.ProtedData) in .Net 2.0 and up to encrypt, > decrypt and protect the keys. Very simple to use. > > ------------------------------------------------------------------------ > ---------- > Roy Chastain > > > > -----Original Message----- > From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2008 11:11 > To: Log4NET User > Subject: RE: How to pass password to AdoNetAppender? > > Thanks Michael. > > But my Problem is that I have to configure the AdoNetAppender with a > config file so I don't have to recompile if I change the database. > > > > > ________________________________ > > From: [EMAIL PROTECTED] > To: [email protected] > Date: Wed, 22 Oct 2008 07:55:41 -0700 > Subject: RE: How to pass password to AdoNetAppender? > > > You can set the connection string in code, here is some sample code, you > only have to do this once and then you can use the AdoNetAppender > multiple times. > > log4net.Config.XmlConfigurator.Configure(); > log4net.Repository.Hierarchy.Hierarchy h = > (log4net.Repository.Hierarchy.Hierarchy) > log4net.LogManager.GetRepository(); > log4net.Appender.AdoNetAppender adoAppender = > (log4net.Appender.AdoNetAppender) > h.Root.GetAppender("AdoNetAppender_UserLog"); > adoAppender.ConnectionString = <set your connection string here>; > > > ________________________________ > > From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2008 7:17 AM > To: Log4NET User > Subject: RE: How to pass password to AdoNetAppender? > > > Thanks Georg. > > Unfortunatly integrated Security is not an option. > Seems it is not as trivial as it seems... > Any other suggestions? > > > Bernhard > > > ________________________________ > > From: [EMAIL PROTECTED] > To: [email protected] > Subject: RE: How to pass password to AdoNetAppender? > Date: Wed, 22 Oct 2008 14:56:36 +0200 > > > > Bernhard, > > > > This maybe of the point in your case, but have you considered using > integrated security? > > > > You could store the username and password encrypted, but then you have > the added problem of securing the encryption key. > > > > Maybe one of the links below is useful: > > > > http://msdn.microsoft.com/en-us/library/89211k9b.aspx > > http://www.theserverside.net/tt/articles/showarticle.tss?id=NewSecurityF > eatures > > > > > > Best regards > > Georg > > Log4Net Dashboard - Log Analysis and Monitoring made easy! > > http://www.l4ndash.com > > > > > > > > From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] > Sent: 22. oktober 2008 14:08 > To: lLog4NET Users > Subject: How to pass password to AdoNetAppender? > > > > Hi, > > another Question from the new guy. > I want to pass the username and password for the database to the > AdoNetAppender. > > The two ways I found were: > * Plaintext in the config file. > * 'Plaintext' in the sourcecode. > > Both ways are not optimal, so were I missing something? Is there a > smarter way of passing a password? > > Thanks in advance. > > Regards > Bernhard > > > > ________________________________ > > Connect to the next generation of MSN Messenger Get it now! > <http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&sou > rce=wlmailtagline> > > > ________________________________ > > Invite your mail contacts to join your friends list with Windows Live > Spaces. It's easy! Try it! > <http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends. > aspx&mkt=en-us> > > ________________________________ > > Discover the new Windows Vista Learn more! > <http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE> > _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
