Re: Enterprise Data Blocks and command timeout

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


There is a command timeout and a connection timeout.. They are not the same
things.

in the1.1 Ent Lib, I had to code up an overload to specify a larger command
timeout.

I have the 2.0 library (not handy unforunately).....and haven't looked at it
yet, but it is probably the same.



<MarkusJNZ@xxxxxxxxx> wrote in message
news:1166166117.638849.151410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi, I am using 2.0 DAB to return a datareader (ASP.NET 2.0)

// Create a database object
Database db =
DatabaseFactory.CreateDatabase("ConnectionString");

I then use the following to return a dataReader

IDataReader _reader = db.ExecuteReader(CommandType.StoredProcedure,
"spStoredProcedureName");

I am experienceing problems where the command times out. How can I set
the command object timeout property when using the above code to
execute a stored procedure against the database??

thanks in advance
Markus



.

Relevant Pages

  • Re: Really need help on this one
    ... Is there a way to read the output of a particular command into ... Heres a better example using ssh. ... set timeout $timeout ... exec kill -9 $pid ...
    (comp.lang.tcl)
  • Re: dd command & reading in background
    ... ^ D,"UnixReview: Shell Corner: The dspl Korn Shell ... user input timeout, do a search on C.U.S. for the ... # 0<c<127 - job exited with this exit code ...
    (comp.unix.shell)
  • Re: C# command doesnt time out appropriately...why?
    ... record in our database that matches the search criteria, ... only by increasing the timeout in our VB application, little by little, ... I'm basically trying to execute the command, which of course is a call ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Timeout
    ... If i increase .commandTimeout to 100, record will be added and database is resized.So it looks like Database resize is done first then record is added. ... Here is the question:For database Resize to happen why i need to increase timeout? ... How SQL Server resize and Client timeout is related? ... >> When I increased Command object timeoutto 120 seconds ...
    (microsoft.public.data.ado)
  • Re: What if Expect buffer overflows
    ... expect_outwhen eof and timeout events happen. ... with your command and see what happens. ... Can anybody please guide what should I do to display the whole info? ...
    (comp.lang.tcl)