[
https://issues.apache.org/jira/browse/LOG4NET-273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14548415#comment-14548415
]
William Bosacker commented on LOG4NET-273:
------------------------------------------
This is definitely an issue, if the System.Data.dll must be in the application
folder. I am not currently certain if this is our issue as well, as our
experience is that the logger sometimes works, but for the most part does not.
Any DLL that is in the Global Assembly cache should not be in the application
folder under any circumstance. If log4net is requiring that the DLL be in the
application folder, then this is a log4net issue.
> AdoNetAppender does not work if you dont copy System.Data.dll
> -------------------------------------------------------------
>
> Key: LOG4NET-273
> URL: https://issues.apache.org/jira/browse/LOG4NET-273
> Project: Log4net
> Issue Type: Wish
> Affects Versions: 1.2.10
> Environment: Windows 7, .Net 2.0
> Reporter: Evald
> Priority: Minor
> Fix For: 1.2 Maintenance Release
>
>
> AdoNetAppender does not work if you dont copy System.Data.dll
> log4net writes at output this line: log4net:ERROR [AdoNetAppender] Failed to
> load connection type [System.Data.SqlClient.SqlConnection, System.Data]
> if you copy the dll than it begin working.
> here it is my config:
> <appender name="SQLAppender" type="log4net.Appender.AdoNetAppender">
> <bufferSize value="1" />
> <connectionType value="System.Data.SqlClient.SqlConnection,
> System.Data" />
> <connectionString value="Data Source=localhost;initial
> catalog=testlog4net;integrated security=false;User ID=sa;Password=mypassword"
> />
> <commandText value="INSERT INTO testlog4net.dbo.Log
> ([Date],[Thread],[LevelName],[Logger],[Message]) VALUES (@log_date, @thread,
> @log_level, @logger, @message)" />
> <parameter>
> <parameterName value="@log_date" />
> <dbType value="Datetime" />
> <layout type="log4net.Layout.PatternLayout"
> value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" />
> </parameter>
> <parameter>
> <parameterName value="@thread" />
> <dbType value="String" />
> <size value="255" />
> <layout type="log4net.Layout.PatternLayout" value="%thread" />
> </parameter>
> <parameter>
> <parameterName value="@log_level" />
> <dbType value="String" />
> <size value="50" />
> <layout type="log4net.Layout.PatternLayout" value="%level" />
> </parameter>
> <parameter>
> <parameterName value="@logger" />
> <dbType value="String" />
> <size value="255" />
> <layout type="log4net.Layout.PatternLayout" value="%logger" />
> </parameter>
> <parameter>
> <parameterName value="@message" />
> <dbType value="String" />
> <size value="4000" />
> <layout type="log4net.Layout.PatternLayout" value="%message" />
> </parameter>
>
> </appender>
> Thank you
> Regards
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
