Re: Timeout Expired Error

Bala wrote:

> Hi !
>
> We are getting a 'Timeout expired' error when using ADO Query and
> when the number of records in the table is large (Delphi 5 and SQL
> Server 2000 Dev Edition used).
>
> The Command Timeout parameter is set to the max value.
>
> Someone pl give suggestions to come out of this pb.
>
> Thanks in advance
>
> With regards,
> Bala

I haven't worked with SQL Server but,

are you trying to fetch the entire table? how does your connection
string look like? and the SQL?

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: SQL Statement or Cursor
    ... Regards, ... SQL Server MVP ... >> Greg Linwood ...
    (microsoft.public.sqlserver.programming)
  • Re: Pb while closing ADO query
    ... Currently we are using SQL Server 2000 Dev edition. ... Regards, ... Bala ... >> Thanks Michael ...
    (borland.public.delphi.database.ado)
  • Re: D5 with ADO
    ... With best regards, ... Bala ... > Any problem expected in using D5 with ADO to connect SQL Server 2000? ...
    (borland.public.delphi.database.ado)
  • Re: what are cursors in sql???
    ... it will be kind enough if anyone helps me in this regards.. ... application code not in SQL. ... If you are new to SQL then my advice is that you ignore cursors until ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Separate Machine Upgrade
    ... Regards ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
Loading