Here a config file for Sybase that works for us:
You can see that we have to specify the Interfaces File path
<appender name="DatabaseAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="0" />
<connectionString value="Provider=Sybase ASE OLE DB
Provider;Interfaces File Server Name=SYBREC_MINET;User
ID=w_miin;Password=w_miin;Interfaces
File=C:\Progra~1\Sybclient\oc_1251\ini\sql.ini;" />
<commandText value="insert into TradingLog_t (logDate, thread,
tradeRef, logger, opCaract, errorMessage, customerMessage, statut,
productType) values (?, ?, ?, ?, ?, ?, ?, ?, ?)" />
<parameter>
<parameterName value="@logDate" />
<dbType value="DateTime" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date{yyyy'-'MM'-'dd HH':'mm}"
/>
</layout>
</parameter>
<parameter>
<parameterName value="@thread" />
<dbType value="AnsiString" />
<size value="10" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%thread" />
</layout>
</parameter>
<parameter>
<parameterName value="@tradeRef" />
<dbType value="AnsiString" />
<size value="25" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{tradeRef}" />
</layout>
</parameter>
<parameter>
<parameterName value="@logger" />
<dbType value="AnsiString" />
<size value="25" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{logger}" />
</layout>
</parameter>
<parameter>
<parameterName value="@opCaract" />
<dbType value="AnsiString" />
<size value="500" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{errorBody}" />
</layout>
</parameter>
<parameter>
<parameterName value="@errorMessage" />
<dbType value="AnsiString" />
<size value="512" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{message}" />
</layout>
</parameter>
<parameter>
<parameterName value="@customerMessage" />
<dbType value="AnsiString" />
<size value="512" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{customerMessage}" />
</layout>
</parameter>
<parameter>
<parameterName value="@statut" />
<dbType value="AnsiString" />
<size value="10" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{statut}" />
</layout>
</parameter>
<parameter>
<parameterName value="@productType" />
<dbType value="AnsiString" />
<size value="20" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{productType}" />
</layout>
</parameter>
</appender>
2009/1/29 Ranjan, Bibhakar <[email protected]>
> iAnywhere.Data.AsaClient.AsaConnection
>
>
>
>
> ------------------------------
>
> *From:* Ron Grabowski [mailto:[email protected]]
> *Sent:* Thursday, January 29, 2009 2:02 AM
> *To:* Log4NET User
> *Subject:* Re: ADO.Net appender configuration for sybase?
>
>
>
> What Sybase type implements IConnection?
>
>
> ------------------------------
>
> *From:* "Ranjan, Bibhakar" <[email protected]>
> *To:* [email protected]
> *Sent:* Wednesday, January 28, 2009 6:21:32 AM
> *Subject:* ADO.Net appender configuration for sybase?
>
> In log4net configuration, we have found sample xml code for most of the
> common RDBMS except Sybase.
>
>
>
> Could you please tell me how can I configure the Sybase database with
> log4net using ADONet appender?
>
>
>
> Thanks
>
> Bibhakar
>
