Click here to Skip to main content
14,878,631 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
It is an 8 years project.I am working on this project since 1 year.ther is a stored procedure to verifiy user login credentials.If every thing is correct then user is logined to that website.

I didn't get any problem till now, from last 2 days i am getting some problems. Users are unable to login into my website.They are entering user name and password and clicking login button, after clicking the login button it saying user and password is incorrect.

But every users is getting same problem.

When i open the log file , in the log file there is exception i.e get_login_user is an stored procedure (skg is username and password is s12@23)

[09-07-2012 09:19:28:094] get_login_user 'skg', 's12@23'
[09-07-2012 09:19:28:172] ExceptionSystem.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



If i restart the Database Server, then they are able login into website.

I am unable to find the problem.

Please help me.

Thanks,

Suresh
Posted
Updated 7-Sep-12 13:12pm
v2
Comments
   
Not enough information.
--SA
deepakaitr12345 8-Sep-12 4:30am
   
This is the very common problem.
if you don't close the connection properly,or do not disposing the reader.
this kind of problem occured.
Please check these 2 things firest

then check it out
whether your log4net getting the database or not.

Hope it will help you

Thanks
bbirajdar 14-Sep-12 2:17am
   
Did you debug the code?

1 solution

This is common problem. Increase your database connection Timeout Time..Means I think problem is happening because of less database connection TimeOut
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900