Re: Recordset Timeout

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


"Bob Butler" <noway@xxxxxxxxxxx> wrote in message
news:%23LZEefADIHA.536@xxxxxxxxxxxxxxxxxxxxxxx
"hon123456" <peterhon321@xxxxxxxxxxxx> wrote in message
news:1192094403.442336.60640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear all,

I am running a Recordset open statement. It prompts error
2147217871 timeout expired.
The following is my statement. How can I set rst.open timeout for
infinity. I cannot find a timeout
property for the Resordset Object.

rst.Open Source:=strsql, ActiveConnection:=cnn, Options:=adCmdText

try setting cnn.commandtimeout

I'm not sure, but I don't think that applies to a Recordset object, nor will
a Recordset object inherit it (the docs clearly state that a Command object
doesn't) . According to the documentation I have, it's for a Connection
object or Command object only. However, you could do this:

cnn.CommandTimeOut = 0
Set rst = cnn.Execute(strsql)

--
Mike
Microsoft MVP Visual Basic


.

Relevant Pages

  • Timeout on recordset retrieval/Opening recordset passing command C
    ... I have a need to open a recordset without a timeout (my current queries, ... despite being adAsyncFetchNonBlocking and running in a separate thread, ... _variant_t vtempty; ...
    (microsoft.public.data.ado)
  • RE: Timeout in VB
    ... "Chakey" wrote: ... and populate it from a view that I am linked to through Access. ... I have no problem creating the recordset from the main table, ... However, now I timeout. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Time tracking attendance
    ... "Theo Geer" wrote: ... Dim rst As Recordset ' This will be the Recordset of your table, ... ' Determine if there is a row where the "TimeOut" has not been entered. ...
    (microsoft.public.access.gettingstarted)
  • Re: Time tracking attendance
    ... Dim rst As Recordset ' This will be the Recordset of your table, ... ' Determine if there is a row where the "TimeOut" has not been entered. ...
    (microsoft.public.access.gettingstarted)
  • Re: Time tracking attendance
    ... Dim rst As Recordset ' This will be the Recordset of your table, ... ' Determine if there is a row where the "TimeOut" has not been entered. ...
    (microsoft.public.access.gettingstarted)