Solved

Delphi 7 :: MS SQL 2005 - Timeout Expired

Posted on 2008-10-02
3
864 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 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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

724 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