Re: ADOConnection TimeOut 30 second, no way to change it ???




thanks, that is the answer.
Not in Delphi 5 where there was a problem in CommandTimeout for TadoQuery and
TadoStoredProc. Use a Tadocommand or TadoDataset and set the commandtimeout
there and you will get it to work.
TadoConnection.commandTimeout is just for using the TadoConnection.Execute
method
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.



Relevant Pages

  • Re: TADOStoredProc
    ... used TadoDataset and TadoCommand instead of TadoStoredProc or TadoQuery ...
    (borland.public.delphi.database.ado)
  • Re: TADOStoredProc
    ... and events to TADOQuery, TADOStoredProc, TADOCommand and TADODataSet. ...
    (borland.public.delphi.database.ado)
  • Re: need stored procedure help
    ... I am using a TAdoDataset to run an MS-SQL stored procedure. ... >I'm using it instead of the TAdoStoredProc because it has a commandtimeout ... If your stored proc doesn't return any values, ... which the TAdoCommand is using to connect to ...
    (borland.public.delphi.database.ado)
  • need stored procedure help
    ... I am using a TAdoDataset to run an MS-SQL stored procedure. ... I'm using it instead of the TAdoStoredProc because it has a commandtimeout ...
    (borland.public.delphi.database.ado)
  • Re: Reducing Command Timeout Property for ADO Connection Object
    ... Use the commandTimeout property of TadoDataset or TadoCommand. ... TadoQuery and TadoStoredProc in D5 had a bug with Commandtimeout so that this ...
    (borland.public.delphi.database.ado)