?
Solved

Delphi 7 :: MS SQL 2005 - Timeout Expired

Posted on 2008-10-02
3
Medium Priority
?
866 Views
Last Modified: 2013-11-23
Dear Experts,

I have search the net for 2 days now in the hope for a solution that will solve my problem.
I managed to find several articles, including EE, explain a solution but none has worked for me.

My SQL query ran fine up until couple of days ago.
And as far as I can remember I did not made any major changes that could severly affect the query results...

But when running a given query (quite long query) I receives a "Timeout Expired" error.

I have changed settings in SQL Management Studio and also on all my components I have set the CommandTimeOut and ConncetionTimeOut properties to large numbers.

Please help URGENTLY....

Thanks.
0
Comment
Question by:Marius0188
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
SteveBay earned 2000 total points
ID: 22623269
Check the recovery model of the DB under Properties>Options. My guess is that it is "Full". Changing it to "Simple" may fix your problem. if this solves the problem then you have an indication of the source of the timeout issue. You will have to decide if "Simple" Recovery model is adequate or if it is necessary to increase you timeout values.
0
 

Author Comment

by:Marius0188
ID: 22631452
Ok I have forgot to add Index on one of the tables that I am refering to in my query.
This seem to do the job...
0
 

Author Comment

by:Marius0188
ID: 22631453
Will give the points anyway as you were only one to respond.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question