Database Trace Listener

May 13, 2008 at 10:13 PM

I have added a database trace listener to my Exception Handling Application Block.

I have configured the connection string which includes a user name and password. (I was able to test the connection to the db using an udl file)

I have added the trace listener to Special Sources > All events

I have created a category (DBCategory) in Category Sources for the database trace listener.

I have created a Policy (DBLog Policy) that has a Logging Handler which references the Log Category above (DBCategory)

When I use the policy in my code, it does not make an entry into the Message table of the special logging db.

I have been able to successfully use the EHAB to write to a flat file and to the event log successfully, but I just can't seem to write to the DB.

Please can someone help me.  I would be most grateful.

Kind regards,

Polly Anna