Delphi 7 :: MS SQL 2005 - Timeout Expired
Posted on 2008-10-02
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....