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.