Please note: If you find any post DOES NOT contain required amount of explanation, please do comment them with a request for more information. I will update as soon as I can attend to it. Also you can contact me with a link to the post.
Symptom: When you start an application using CLR profiler, it always says [waiting for application to start common language runtime] and wait forever
Resolution
- Most probably you may be using CLR Profiler 1.1 to profile .NET 2.0 Application. Download CLR Profiler 2.0 from the here
If it is VISTA or Windows XP, may be CLR Profiler doesn't have enough permissions to run. Try running CLR Profiler as an Administrator.
Right Click on the CLRProfiler.exe -> Run as -> Administrator
Symptom: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Resolution:
- SqlConnection: If this happen when tries to connecting to SQL Server, then try increasing the timeout of the connection
Connection String: server=Server;database=Database;uid=Uid;pwd=Pwd;timeout=600 (ConnectionTimeout is read-only)
- SqlCommand: More interestingly if you manage to connect successfully and although you set a fat timeout value to your connection command object does not inherit the timeout from its connection. It uses its own timeout value. More logically ConnectionTimeout and CommandTimeout.
So increase the timeout of the command, which is not read-only like SQLConnection
command.CommandTimeot = 600 (set to 10 minutes)
Reference: ASP.NET Forums