.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Database Trace Listener in the Enterprise Library doesnt work

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :ASP.Net

I am having a problem on the Database Trace Listener in the Enterprise Library. I have created the database trace listener and and the procedures and tables, but the data is not logged in the table.  Thank you very much.

I need to log data in file and db both. If i comment the database listener, the file listener works but it doesnt work with the database listener. And the database listener doesnt work in any case. Connection string has no problem.

Here's my web.config:

<loggingConfiguration name="Logging Application Block" tracingEnabled="true" defaultCategory="GeneralLog" logWarningsWhenNoCategoriesMatch="true">
      <add databaseInstanceName="WEBJunctionDbServer" writeLogStoredProcName="WriteLog"
          addCategoryStoredProcName="AddCategory" formatter="Text Formatter"
          listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Database.Configuration.FormattedDatabaseTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging.Database, Version=, Culture=neutral, PublicKeyToken=null"
          traceOutputOptions="None" type="Microsoft.Practices.EnterpriseLibrary.Logging.Database.Form

View Complete Post

More Related Resource Links

Help- Enterprise Library Logging Block (Database trace listener)



I'm new to enterprise application blocks. I'm trying to use database trace listener to write the logs to Database. Can someone help me on this .

I would apprciate your response.







Enterprise Library 3.1 database logging


Im new in using Microsoft Enterprise Library 3.1. Im trying to run database Logging.
I added the required configuration to the web config as mentioned in MSDN library. then I ran the script to generate logging tables and stored procedures.

I changed the formatter template to keep needed data. below is sample of my code

Dim ologEntry As LogEntry = New LogEntry()
        With ologEntry
            .Severity = Diagnostics.TraceEventType.Error
            .Title = "MSEntLib3.1"
            .AppDomainName = AppDomain.CurrentDomain.BaseDirectory
            .ProcessName = "TestFunction()"
            .Message = "Informational message"
        End With


I faced an error that there are missing paramters then I modified writeLog stored Procedure to recieve the listed above paramaters, I test it on sql server its working fine, in my web page it doesnt rais an error and not inserting any data to the log table.

How to load "Database Instance" for "Database Trace Listener" at runtime



I have been searching for a while now without success. On how when using EntLib 5.0 Logging, Data; to be able to set the database (i.e. the connection string) at runtime for a Database Trace Listener. The reason being we will have the same configurations on all levels of the environments (dev, test, stage, prod), but the connection string is different for each and we do not store the connection string data in the config file. The connection string data is loaded using a custom configuration manager for security reasons.


Any help and any code sample much appreciated. 



Add Stack Trace in trace.log file using Enterprise library 5.0



I am facing one issue while using trace.log file for logging the exceptions. I need to get the stack trace with other exception information. But stack trace is not available with provide enterprise library 5.0 exception logging template. Is there any way I can add this.

Also I want to genrate seprate trace.log file for every day.


MVC + Enterprise Library


Not a MVC specific question, but as that's what I'm doing I thought I'll post here.

While looking into the source code of an existing application, I stumbled upon MS Enterprise Library, and as I only heard about these "application block" stuff decided to look into it.

From the theory it sounds like a pretty usefull thing and it made me wonder if other's are using it succesfully along with MVC projects (I know they are not really related!)?

Pro's and Con's? 

I like the database block, as I did not get to any real database development the last 1.5 years, for instance. (Bad excuse I know).  Having an IoC thrown in there (Unity) sounds like I can pretty much stop using 3rd party libraries like I do now all over the place.

Using the ConsoleTraceListener with the Enterprise Library 3.1 Logging Block


I'm new to using the Logging application block.  I think I have a pretty good handle on how things work.  However, I'm running into a problem.  I'm using the RollingFlatFileListener and I have formatted the logging template to be more like the logging we are replacing.  However, in our console apps when the ConsoleTraceListener is added it still logs it out in the default text template format.  Is there any way to get around this?  Currently it looks like I will have to create a new TraceListener called FormattedConsoleListener that allows a text formatter to be associated with it.  Is this the only way?

Data Truncation issue with Enterprise Library Logging WriteLog stored Proc


Hi ,

I'm using Enterprise Library Logging  feature for logging. The issue i am facing is when the Logging message is too large(more than 65534 chars) ,complete data  is not logged in the Formatted Mesage column which is  of data Type nText .

I am able insert complete data if i try inserting from Sql insert Query from sql management studio. Do i need to add any attributes to data base listener or do i need to change the sp.

 Is there any way to increase the WriteLog stored proc param size in EnterpriseLibrary.Logging config file ? . Please let me know.


Thanks In Advance.

Using Enterprise Library for first time



I wan to use the enterprise library for the first time. Is there any samples, quick start guide or ebook is available for a quick start and learn the basics.

I have vs2008, so which version of EL should I use?

And if somebody can just brief about Enterprise Library. Because as per my understanding, is this a mixture of design patterns and some pre-made blocks of source code.





Enterprise Library: Take Exception To Critical Errors With Custom Application Blocks


Enterprise Library is a collection of application functionality blocks that you can re-use in your application for common functionality you'd otherwise have to write again and again. Here Jay Hilyard explains how to use them.

Jay Hilyard

MSDN Magazine September 2006

Data Points: The Enterprise Library Data Access Application Block, Part 3


E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.

John Papa

MSDN Magazine October 2005

Data Points: The Enterprise Library Data Access Application Block, Part 2


Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).

John Papa

MSDN Magazine August 2005

Data Points: The Enterprise Library Data Access Application Block, Part 1


A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.

John Papa

MSDN Magazine July 2005

Using SQL Server 2008 R2 client with Enterprise Library



I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?


Getting my sql database app to work on any windows pc

Hello I have just made a vb.net database application using visual studio 2008 with the service based database component. The application works fine on my pc but when i copy my application and the .mdf file and test it on another windows pc that does not have visual studio 2008 installed it  says that sql server is not propery configured and or is missing. I am just wondering how I can configure the sql server so that my application can read,save,add, delete my stored data on any pc. I tried to install the sqlsetup files but I still get the same error message. Would appreciate if someone could give some hints or help with this issue. Thanks!    

Shielding Exceptions at WCF Service Boundaries using Microsoft Enterprise Library 4.1

To enable the exception shielding feature in my WCF service I have done the following steps Added references of the following assemblies: Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.dll Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.WCF.dll Microsoft.Practices.EnterpriseLibrary.Common.dll Microsoft.Practices.ObjectBuilder2.dll Added a Using statement for Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.WCF. Added the ExceptionShielding attribute to a service implementation class and specified the name of the exception policy to use as a constructor parameter. Add the Exception Handling Application Block configuration sections to the service's Web.config file. <add name="WCFServicePropogate">         <exceptionTypes>           <add type="System.Exception, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089"             postHandlingAction="ThrowNewException" name="Exception">             <exceptionHandlers>               <add exceptionMessage="I created the exception" faultContractType=

Architecture / Enterprise Library /EF4

Hi there, Recently i have joined a new project that is to be build from scratch.(goal of the project is to reach the users across boundaries : windows, web & mobile)I follow architecture having following layers:1.Presentation Layer 2. Logic Layer(BLL)  3. Business Objects  4. Data Access Layer.But this time i wanted to use new technologies Microsoft have introduced like Entity Framework 4.0 , WCF services.So i have thought of  creating the layers like1.Presentation    2. BLL  3.Services  4.Business Objects   5.DALbut i am in confusing state how to use Entity Framework. in the above layered diagram.Please suggest or guide me.If there any flaws in the above layered diagram do guide me.I have heard of Microsoft Enterprise Library(MEL) 5.0. What exactly it is?Will i get benefited with MEL 5.0.Suggestion are highly expected.thanx for ur time.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend