Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Asp Net SqlConnection Monday, January 22, 2007
When you are trying to connect or access from a Database table which is having large volume of data (more than a lakh), query execution time will be more.
The error ( Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.) occurs when the execution time crosses Timeout Property.
There are two main Timeout property in ADO.NET.
1. Connection Timeout for Connection
2. Timeout for Data Access( Command Object or DataAdapter)
The Former, could be solved by setting ConnectionTimeout Property of Connection object either in on Connection String.
Even after this, you may still get the same.
Because this property will set timeout only to Connection object.
So it will wait for xxx seconds for the connection to the database.
2.If this error Timeout Expired still persists, then it is not with the Timeout property of Connection object instead it is with Data Provider objects say in DataAdapter or Command Object
To overcome this , set Command.Timeout='0'(Zero) which makes adapter or command to wait for indefinite time before terminating the attempt to execute a command and generating an error.
Complete Forum Discussion in ASP.NET Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Asp Net SqlConnection
posted by TechieLion @ 12:44 AM, ,
Asp Net Unable to start debugging. Monday, January 8, 2007
Error Message:ASP NET Unable To Start Debugging
The Error Message Unable to start debugging, will be displayed in the browser, when you try to debug an asp.net application.
The Problem could have happened by one of these.
1. Check the existence of web.config file in your application.
If its not there, create one web.config file.
2. If its there already, check for its xml formation of tags.
Make sure that this is well formed and the debug section should be like this below.
For more information::
PRB:ASP NET Unable to Start Debugging:
posted by TechieLion @ 1:14 AM, ,