I am using LLBLGen v2.6 Final (Oct. 9th 2009) with the .NET 2.0 SQL Server self servicing templates in an ASP.NET project.

I read the documentation and posts here and it seemed easy enough to enable tracing. Here is my app.config file:

<?xml version="1.0"?> <configuration> <appSettings> <add key="Main.ConnectionString" value="data source=.\SQLEXPRESS;initial catalog=SBS;integrated security=SSPI;persist security info=False;packet size=4096"/> </appSettings>

<system.diagnostics> <switches> <add name="SqlServerDQE" value="4" /> <add name="ORMGeneral" value="4" /> <add name="ORMStateManagement" value="4" /> <add name="ORMPersistenceExecution" value="4" /> </switches> </system.diagnostics> </configuration>

But I don't see anything in the output window when I execute a retrieval query. Specifically, I am looking for the SQL that executes during the retrieval operation. I originally had just the ORMPersistenceExecution value set to 4, but turned them all on to see if I had set the wrong one. Not only am I not seeing the SQL, I'm not seeing any trace information at all. I know this must be some oversight on my part, but I've tried several things and I'm not getting anywhere. Can you please tell me what I'm doing wrong?

Are you sure you are placing the trace configuration in the correct file? You mentioned "app.config". It should be in the "web.config" on you ASP.Net Web project.

Thanks for that - of course it works perfectly now. I am new to ASP.NET, so I wasn't aware there was a separate config file. My co-worker would have known, but he was gone for the day and I was trying to get some things done over the weekend.

jlkInChantillyVA wrote:

Thanks for that - of course it works perfectly now. I am new to ASP.NET, so I wasn't aware there was a separate config file. My co-worker would have known, but he was gone for the day and I was trying to get some things done over the weekend.

No worries . Come back here if you need further help.