SQL timeout (2)

Micha Broede

unread,

Mar 30, 1999, 3:00:00 AM3/30/99

to

Hi,
I don't have a solution for the problem published here some days before:

I've built a Delphi application to execute stored procedures for
Microsoft-SQL-Server.
The connect to MS-SQL-Server is realized with Delphi-BDE-MSSQL driver
(not ODBC!).
Some stored procedures works to begin without activity on client side
(for instance to create temp-tables and prepare datas). This is not
unusual, isn't it? And now I get a timeout after a few minutes when I
open such stored procedure in Delphi. Is this normal?

I wonder about the small resonance up to now. I think that is an
important problem, general.
Are there any suggestions?
Best regards
Michael

(using Delphi 4.0 C/S and MS-SQL 6.5)

RathnaRaj

unread,

Mar 31, 1999, 3:00:00 AM3/31/99

to

This could be possible. If you set timeout to a small value and your stored
proc takes a while to finish execution time out will happen, as there is no
activity from client end.

If you foresee that your stored procedures taking long time to execute you
can change the timeout value temporarily before start of the stored proc
execution and set it back to the old value after the execution is complete.

Hope it helps

Regards

RathnaRaj

Micha Broede <m...@gecko.de> wrote in message
news:3700D90B...@gecko.de...

Micha Broede

unread,

Apr 1, 1999, 3:00:00 AM4/1/99

to

Hi and thanks,
but the true problem is, the TIMEOUT parameter doesn't work (I wrote about this
here some days before). I can set this parameter to various values and it
seems, the Delphi client does not take notice of it and terminate the SQL
connection always after a constant few of minutes (~ 5 to 7 min).
Do you have an idea?
Regards
Micha

RathnaRaj schrieb:

Trevor Toms

unread,

Apr 3, 1999, 3:00:00 AM4/3/99

to

You need to change the timeout properties on the Configuration tab rather
than the Databases tab. Select Configuration | Drivers | Native | MSSQL,
and alter the two settings TIMEOUT and MAX QUERY TIME.

I don't know why this doesn't work on the individual database aliases.

Trevor Toms

In article <37031D09...@gecko.de>, m...@gecko.de (Micha Broede)
wrote:

Allen Davidson

unread,

Apr 4, 1999, 4:00:00 AM4/4/99

to

I too have tried to set this param for an alias at run time but it does
not work. Anyone from team B care to comment?

--
Regards Allen

Allen Davidson

Toan N

unread,

Apr 5, 1999, 3:00:00 AM4/5/99

to

You may have to set the "Remote Connection TimeOut" parameter inside the
MS/SQL Server using SQL Enterprise Manager. It works for me. Make sure after
each change, you must stop/start the MS/SQL server

Toan

Micha Broede

unread,

Apr 6, 1999, 3:00:00 AM4/6/99

to

Hi and thank you very mutch,
this is a solution, not good but sufficient to execute stored procedures with
a longer timeout behaviour.
I think, it's a big fault, that it is not possible to set the timeout
parameters for an individual database client at runtime in delphi! How should
I handle in this way several stored procs or db clients?

Best regards
Michael

Trevor Toms schrieb:

Trevor Toms

unread,

Apr 6, 1999, 3:00:00 AM4/6/99

to

I don't use stored procedures in my applications and so cannot help you on
that one. Sorry.

Trevor Toms

In article <3709C107...@gecko.de>, m...@gecko.de (Micha Broede)
wrote:

> Hi and thank you very mutch,

Boudenoodt

unread,

May 6, 1999, 3:00:00 AM5/6/99

to

Hi
I use a timer and every few minutes I execute a dummy stored procedure
You don't have to change the sql server settings and the stored proc is
really small
and it works for me

Herman

Trevor Toms <sm...@msn.com> wrote in message
news:memo.1999040...@tt.msn.com...