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

Hi,

i am using Delphi 5 and MsSQL 2000.

i use ADOConnection component to connect to SQL Server and using TQuey to
execute some store procedure. From Delphi help file, the default
CommandTimeOut
is 30 second and i had change the ADOConnection property as below:

AdoConnection.CommandTimeout := 600; // 10 minute
AdoConnection.ConnectionTimeout := 20;

When i execute the store procedure, it look like the setting is no effect
and the i am getting
time out problem as below ( i have log it )


XXXXX ( sp Name ) : Start at 25-06-2007 12:09:22 PM
25-06-2007 12:09:53 PM Error :Timeout expired


XXXXX ( sp Name ) : Start at 25-06-2007 12:10:30 PM
25-06-2007 12:11:01 PM Error :Timeout expired

It look like the CommandTimeOut still is 30 second, please help !!!!

* I had change the SQL server setting for Query Time out to 600 second and
if i execute
the same store procedure with same parameter in SQL Query Analyse, it
success to run.

* i try to use BDS2006 to compile the source and i still getting the same
error.

Please Help !!!!


.

Relevant Pages

  • Update or Insert in tableadapter not working
    ... Hi, I have a store procedure to insert, and I use tableadapter to execute this store procedure, when I run the application and execute the sp with: ... or Any idea to execute the store procedure to insert or delete or update rows in SQL Server 2005 data base using C# 2005. ...
    (microsoft.public.dotnet.framework.adonet)
  • Insert and update dont work
    ... Hi, I have a store procedure to insert, and I use tableadapter to ... execute this store procedure, when I run the application and execute the ... insert or delete or update rows in SQL Server 2005 data base using C# ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Insert and update dont work
    ... > execute this store procedure, when I run the application and execute the ... > and after I see the datagridview and the new row is there, ... > insert or delete or update rows in SQL Server 2005 data base using C# ...
    (microsoft.public.dotnet.languages.csharp)
  • settings: ARITHABORT
    ... I have a .Net application that executes a store procedure, ... execute fine until I added a clustered unique index to one of the view .This ... But I am not able to reproduce the error when I execute the store procedure ... from the SQL server and happens only when called from my application. ...
    (microsoft.public.sqlserver.programming)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)