Re: command timeout does not work

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

How do you execute your SP? Are you using Execute method of Command or
Connection object?
Also check if this is not your case

http://support.microsoft.com/default.aspx?scid=kb;en-us;188858

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"rani" <raniz@xxxxxxxxx> wrote in message
news:%23ZPZimQcFHA.3488@xxxxxxxxxxxxxxxxxxxxxxx
> Hello,
> I'd appreciate a hint as to how to solve the problem, if anyone heard, or
> bumped into one like this:
>
> I'm running a Stored procedure using ADO 2.6 VB6 against sql server 2000.
> I'm using the default commandTimeout (30 sec.), but I don't get the
> expected
> "timeout expired" exception after the 30 seconds. Within the stored
> procedure it runs another stored procedure using "sp_executesql".
> The 2nd Stored Procedure returns a Record, while the 1st is not selecting
> anything. The two stored procedures run on two different servers which are
> linked servers.
>
> The ADO query does not run in Transaction nor does any transaction opened
> in
> any of the stored procedures.
> SET NOCOUNT ON is set in both Stored procedures.
> The 2nd stored procedure runs a "heavy" query creating many temporary
> tables
> (#table), inserting data and updating in these tables.
>
> Does anyone have a clue of why I don't get the timeout on time?
>
> Is it possible that ADO waits more than 30 sec. for some kind of rollback
> to
> take place?
>
> Thanks Rani
>
>


.

Relevant Pages

  • Re: Need help with Stored Procedures being called from Client Code.
    ... Although I totally advocate the use of Stored Procs for many reasons, ... Performance and Security aren't a slam dunk with procs - you can do the same ... you need to set a command for each operation that you are ... > I created the stored procedures for Select, Insert, Update and Delete ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need help with Stored Procedures being called from Client Code.
    ... Each command property will get its own SQL Statement or procedure name. ... > but I have all those SQL statements in my stored proc!! ... >>> commandText property of the sqldataadapter or doesn't? ... >>>> I created the stored procedures for Select, Insert, Update and Delete ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How the frick do you call a stored procedure when using OdbcDataAdapter?!?
    ... you use Command objects to interact with the data source. ... you are going to be using stored procedures, ... connectionType to StoredProc. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Autimatic Stored Proc Generation
    ... update and delete stored procedures automatically for you. ... DataAdapter wizard to generate it. ... Use Query Builder to create the SELECT command. ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "Display Dependencies" not showing all dependencies
    ... do you have to recompile all stored procedures? ... This will generate the command for procs and functions, ... copy the output from the bottom pane to the upper pane or a new window. ...
    (microsoft.public.sqlserver.server)