Hi, Not sure if this helps.
Can you connection string point to something like this www.somewhere.com as your DNS alias and in your dns entries www.somewhere.com maps to your IP. This way if you switch the database around, all you do is map the DNS alias to a new IP as long as the schemas as same? From: Bernhard Heinzel [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2008 11:11 AM 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>
