Click here to Skip to main content
15,893,381 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an application which was running absolutely fine till 1 week ago, I have made no change in the application code since an year, suddenly it has started showing the inconsistency. Sometimes it fetches the result from database, sometimes it does not. The user is able to login to the system but is not able to perform serach from the database. The issues seems to be due to the database it may be either connectivity or something. What can be the possible issues that I should check to get this resolved?

Thanks in Advance,
Deepti
Posted
Comments
Herman<T>.Instance 23-Apr-12 5:45am    
is there any errormessage given?(application log)

Your issue is too vague without more information.

Try :
1) Restarting the server/services
2) Running : dbcc upateusage on your database
 
Share this answer
 
Comments
deeptibansal 25-Apr-12 1:14am    
still stuck with the same issue. one more application is there hosted on the same server and database also on the same server as the problemetic application but that seems to work fine... but this application does not have much data. Does it give any clue to the problem resolution?
It was a connectivity issue on hosting team part.
 
Share this answer
 
Hi,

It may be occurred due to one of the following reasons

- Database might be deleted
- Database might be renamed
- Incorrect connection string/ connection configuration set in the config file of application.

Just ensure the checklist which are passed.
 
Share this answer
 
Comments
deeptibansal 23-Apr-12 6:33am    
None of these issues exists as sometimes it gives the correct result and I have also checked that database has not been deleted/renamed and connection string is also correct.

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