Problem occurring of Sql Exception - Timeout Expired Error in ASP.NET

Question

0.00/5 (No votes)

See more:

, +

While executing stored procedure from sql server then it takes less than 3 sec to execute. but when i exceute it from asp.net code then it gives Time out expired error - Sql Exception..

Please provide me any solution....

i have searched a lot but didn't find any best solution. i found somewhere to increase timeout period of sql command..i did it but it slows down the exceution of stored procedure from asp.net code.... but my query is even fast at sql server end.

Posted 21-Jul-14 19:22pm

Gaurav Gupta A Tech Guy

Add a Solution

Comments

deepakaitr12345 22-Jul-14 2:17am

Hi @Gaurav

I think this is the common problem with the code that is,Connection is not properly closed,
My suggestion over here is dispose or close the connection check the sp_lock command on the sql server when you exicute the Sp and find the locking object which cause exclusive lock.

or Remove connection oriented object.
Hope this help you
Thanks

krishnaMurali 22-Jul-14 3:13am

try above suggestion or.. can you provide the method code, in which you are calling SP

Gaurav Gupta A Tech Guy 24-Jul-14 2:10am

i am using Microsoft.Practices.EnterpriseLibrary.Data library for database connection...and it automatically open and close db connection... so what should i do now....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kumarbs · Answer 1 · 2014-07-22T19:17:00

Solution 1

Try to use the CommandTimeout = 0 in your asp.net query, if you are using SqlHelper then you need to replace that with the ADO.Net objects.

Posted 22-Jul-14 19:17pm

Kumarbs

Comments

Gaurav Gupta A Tech Guy 24-Jul-14 2:11am

i am using Microsoft.Practices.EnterpriseLibrary.Data library for database connection...so what should i do now....

Kumarbs 24-Jul-14 2:30am

I understand that you are using DbCommand class to establish the connections and execute the commands, if so, for that also you can make the DbCommand.CommandTimeOut = 0 so that the process will wait until you get the records. If you are using "Using" class for execution of procudre or query, try to remove that as it has some problems in closing the connections as per my understanding. Let me know if it solves your pblm.

Gaurav Gupta A Tech Guy 28-Jul-14 6:22am

Yes....i got it.....i will try this. i will inform you if get succussfull......