Using Log4Net with Oracle

[Farley Susan <fa...@bah.com>]

 
As our application is distributed, I am trying to log messages to our
Oracle database. In the app.config, I have the following:

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"
	<bufferSize value="1" />
	<connectionType
value="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess,
Version 10.1.0.200, 				Culture=neutral,
PublicKeyToken=89b483f429c47342"/>
	<connectionString value="Data Source=(local); user id = user;
password = password"/>
....
</appender>

When I run my application and the database appender tries to initialize,
I get the following error in the log4net.Appender.AdoNetAppender
ResolveConnectionType function:
"File or assembly name Oracle.DataAccess, or one of its dependencies,
was not found."
And clues as to how to resolve this problem? I'm using Log4Net 1.2.10

Thank you,
Susan

Re: Using Log4Net with Oracle

[Ron Grabowski <ro...@yahoo.com>]

Do you have Oracle.DataAccess.dll in the application's bin directory?
Have you tried using the Oracle provider from the System.Data
namespace:

<connectionType value="System.Data.OracleClient.OracleConnection,
System.Data.OracleClient" />

http://tinyurl.com/75k4w
http://logging.apache.org/log4net/release/config-examples.html#adonetappender-o9

--- Farley Susan <fa...@bah.com> wrote:

>  
> As our application is distributed, I am trying to log messages to our
> Oracle database. In the app.config, I have the following:
> 
> <appender name="AdoNetAppender"
> type="log4net.Appender.AdoNetAppender"
> 	<bufferSize value="1" />
> 	<connectionType
> value="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess,
> Version 10.1.0.200, 				Culture=neutral,
> PublicKeyToken=89b483f429c47342"/>
> 	<connectionString value="Data Source=(local); user id = user;
> password = password"/>
> ....
> </appender>
> 
> When I run my application and the database appender tries to
> initialize,
> I get the following error in the log4net.Appender.AdoNetAppender
> ResolveConnectionType function:
> "File or assembly name Oracle.DataAccess, or one of its dependencies,
> was not found."
> And clues as to how to resolve this problem? I'm using Log4Net 1.2.10
> 
> Thank you,
> Susan
>