Solved

Delphi 7 :: MS SQL 2005 - Timeout Expired

Posted on 2008-10-02
3
860 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
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
SteveBay earned 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SHOWPLAN permission denied in database 'AdventureWorks'. 13 111
Firemonkey android show image from resource ? 1 46
How to build JSON File in Delphi 6 3 46
SQL Error - Query 6 42
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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

820 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