RE: Sqlce push/pull timeout over GPRS

From: Brad Syputa - MS (bradsy_at_Online.Microsoft.com)
Date: 04/04/04

  • Next message: Brad Syputa - MS: "RE: RDA Problems" 
    Date: Sun, 04 Apr 2004 22:26:44 GMT

    For RDA, Command Timeout is not a parameter that will be used. There is no
    easily effective way to halt the RDA sync short of reseting the device
    (from my experience). Once it starts, it will make all attempts possible to
    finish the Push or Pull. If the connection is lost, it will timeout looking
    for the IIS Server after about 2 minutes.

    --------------------
    | Reply-To: "Simon" <info@geoaps.com>
    | From: "Simon" <info@geoaps.com>
    | Subject: Sqlce push/pull timeout over GPRS
    | Date: Fri, 2 Apr 2004 21:54:35 +0100
    | Lines: 27
    | Organization: geoaps
    | X-Priority: 3
    | X-MSMail-Priority: Normal
    | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
    | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
    | Message-ID: <usQB2SPGEHA.3096@TK2MSFTNGP11.phx.gbl>
    | Newsgroups: microsoft.public.sqlserver.ce
    | NNTP-Posting-Host: 82-34-88-31.cable.ubr05.gill.blueyonder.co.uk
    82.34.88.31
    | Path:
    cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
    .phx.gbl
    | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:11847
    | X-Tomcat-NG: microsoft.public.sqlserver.ce
    |
    | Hello,
    |
    | I am using sqlce to push/pull data over gprs. The same transaction can
    take
    | from 2 seconds up to 5 or 6 minutes depending upon (I suppose) the GPRS
    | connection. I have tried to set the timeout on the connection and the
    | command to 30 seconds using the code shown below. Neither method seems to
    | work. This is causing problems because the pocket pc is locked up for as
    | long as the data transfer takes.
    |
    | Dim rdaOleDbConnectString As String =
    | "Provider=SQLOLEDB.1;Password=pwrd;Persist Security Info=True;User
    | ID=Usid;Initial Catalog=SD_Dbase;Data Source=123.123.123.123; Connection
    | Timeout=30"
    | Dim rdaOleDbConnectString As String =
    | "Provider=SQLOLEDB.1;Password=pwrd;Persist Security Info=True;User
    | ID=Usid;Initial Catalog=SD_Dbase;Data Source=123.123.123.123; Command
    | Timeout=30"
    |
    | Neither of the above seem to actually timeout and stop the transmission if
    | it has not connected or completed in 30 seconds, does anyone know if the
    | command format is wrong or any other ideas?
    |
    | Thanks
    |
    | Simon
    |
    |
    |

  • Next message: Brad Syputa - MS: "RE: RDA Problems"

    Relevant Pages

    • Re: ADO.NET timeout
      ... that connection timeout and command timeout are ... >> In addition to Val's good advice, you can also set the connection timeout ... >> Enterprise Development with VS .NET, UML, and MSF ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: ADO.NET timeout
      ... that connection timeout and command timeout are different ... Simple specify the Connection ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Connection Timeout
      ... I set the general timeout, however, this property like the connection ... The connection timeout and the extended command timeout are two differents ... Sylvain Lafontaine, ing. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Increase Connection Command timeout globally
      ... this is not a function of any SP code or anything done on the server. ... Connection and Command timeout settings are done on the client. ...
      (microsoft.public.dotnet.framework.adonet)
    • 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)