Error using ADONetAppender

[Ping Xie]

Hi,

I'm try to log messages to Oracle database. I got the following debug errors when run my application.

-------------------------------------------------------------------------------------------------------------------------------
log4net:ERROR [ADONetAppender] Failed to load connection type [System.Data.Oracl
eClient.OracleConnection,System.Data.OracleClient, Version=1.2.0.30714, Culture=
neutral,PublicKeyToken=b32731d11ce58905]
System.IO.FileLoadException: The located assembly's manifest definition with nam
e 'System.Data.OracleClient' does not match the assembly reference.
File name: "System.Data.OracleClient"
   at System.Type.GetType(String typeName, Boolean throwOnError)
   at log4net.Appender.ADONetAppender.ResolveConnectionType()

=== Pre-bind state information ===
LOG: DisplayName = System.Data.OracleClient, Version=1.2.0.30714, Culture=neutra
l, PublicKeyToken=b32731d11ce58905
 (Fully-specified)
LOG: Appbase = C:\hv\HF Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu
torials\ConsoleApp\cs\build\debug\
LOG: Initial PrivatePath = NULL
Calling assembly : log4net, Version=1.2.0.30714, Culture=neutral, PublicKeyToken
=b32731d11ce58905.
===

LOG: Publisher policy file is not found.
LOG: Host configuration file not found.
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1
.1.4322\config\machine.config.
LOG: Post-policy reference: System.Data.OracleClient, Version=1.2.0.30714, Cultu
re=neutral, PublicKeyToken=b32731d11ce58905
LOG: Attempting download of new URL file:///C:/hv/HF Security/Log4net/log4net-1.
2.0-beta8/examples/net/1.0/Tutorials/ConsoleApp/cs/build/debug/System.Data.Oracl
eClient.DLL.
WRN: Comparing the assembly name resulted in the mismatch: Minor Version

-----------------------------------------------------------------------------------------------------------------------------

The following is the ADONetAppender portion of my config file. Does anyone know what is wrong?

----------------------------------------------------------------------------------------------------------------------------
        <appender name="ADONetAppender_Oracle" type="log4net.Appender.ADONetAppender" >
                    <param name="ConnectionType" value="System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.2.0.30714, Culture=neutral,PublicKeyToken=b32731d11ce58905" />
                            <param name="ConnectionString" value="data source=[netbltsdb1];User ID=[docex];Password=[docex]" />
                            <param name="CommandText" value="INSERT INTO Log (Datetime, Thread,Log_Level,Logger,Message) VALUES (:log_date,:thread,:log_level,:logger,:message)" />
                    <param name="BufferSize" value="128" />
                    <param name="Parameter">
                        <param name="ParameterName" value=":log_date" />
                        <param name="DbType" value="Date" />
                        <param name="Layout" type="log4net.Layout.RawTimeStampLayout" />
                    </param>
                    <param name="Parameter">
                        <param name="ParameterName" value=":thread" />
                        <param name="DbType" value="String" />
                        <param name="Size" value="255" />
                        <param name="Layout" type="log4net.Layout.PatternLayout">
                                <param name="ConversionPattern" value="%t" />
                        </param>
                    </param>
                    <param name="Parameter">
                        <param name="ParameterName" value=":log_level" />
                        <param name="DbType" value="String" />
                        <param name="Size" value="50" />
                        <param name="Layout" type="log4net.Layout.PatternLayout">
                                <param name="ConversionPattern" value="%p" />
                        </param>
                    </param>
                    <param name="Parameter">
                        <param name="ParameterName" value=":logger" />
                        <param name="DbType" value="String" />
                        <param name="Size" value="255" />
                        <param name="Layout" type="log4net.Layout.PatternLayout">
                                <param name="ConversionPattern" value="%c" />
                        </param>
                    </param>
                    <param name="Parameter">
                        <param name="ParameterName" value=":message" />
                        <param name="DbType" value="String" />
                        <param name="Size" value="4000" />
                        <param name="Layout" type="log4net.Layout.PatternLayout">
                                <param name="ConversionPattern" value="%m" />
                        </param>
                    </param>
        </appender>
------------------------------------------------------------------------------------------------------------------------------------

Thank you in advance.

Ping Xie

CACI
4831 Walden Lane
Lanham, MD 20706
[EMAIL PROTECTED]
(301) 306-8200 - Main
(301) 306-2829 - Direct