Re: How to Change The Timeout on TADOStoredProc component

Thank you Kevin.
It works great with TADOCommand

"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4332acbc$2@xxxxxxxxxxxxxxxxxxxxxxxxx
> Rumen,
>
> That is a 'undocumented feature' with the TADOStoredProc/TADOQuery. Use
> TADOCommand instead.
>
> Good luck,
> krf
>
> "Rumen" <rpetrov@xxxxxxxxxxxx> wrote in message
> news:43320250@xxxxxxxxxxxxxxxxxxxxxxxxx
>> Hi all,
>> I have this problem of stored procedure timing out if I have to much data
> in
>> my database.
>> It takes more than the default 30 seconds to be executed so I want to
> change
>> the timeout from 30 to 60 seconds.
>> Unfortunately I can't seem to find a way to do that. I tried changing the
>> CommandTimeout and ConnectionTimeout of the
>>
>> TADOConnectin component that TADOStoredProc is using for Connection but
>> it
>> doesn't work.
>> Any ideas?
>> I'm using Delphi 5.
>>
>> Thanks a lot,
>> Rumen
>>
>>
>
>


.