Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Asp Net SqlConnection

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.

This string will make a connection object to wait 400 seconds to get connected to the database.

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, , links to this post

kick it on DotNetKicks.com

Asp Net Unable to start debugging.

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, , links to this post

kick it on DotNetKicks.com