Solved

Delphi 7 :: MS SQL 2005 - Timeout Expired

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now