Connection Timeout

See if this answers your question:
http://classicasp.aspfaq.com/general/how-do-i-increase-timeout-values.html
Andrew J. Kelly SQL MVP
"tc" <tull@.idcodeware.co.uk> wrote in message
news:uDuIIqhzHHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hi all.
> I have a PPC app which connects to an SQL server via RF. App is fine, but
> when
> out of range the connection timeout is too long. I don't want to backlog
> data, in this instance the user must be within range for the connection
> to
> work. Using CF SQLClient namespace.
> I've had a look at the general sql client connection properties, but I
> can't
> find a way to reduce the connection timeout to say, 5 seconds.
> Any ideas?
>
>
I don't see the distinction for this. It is just a property (CommandTimeOut)
that you set for the connection. It should not matter what the client or the
server is or what they do.
Andrew J. Kelly SQL MVP
"tc" <tull@.idcodeware.co.uk> wrote in message
news:ujKRwhpzHHA.1204@.TK2MSFTNGP03.phx.gbl...
> It's the right idea, but I need to impose this change within my managed VB
> code on the portable, I'm not loading data from a web server, just a
> standard SQL server on a local network.
> Thanks anyway.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:O5nkQPizHHA.3600@.TK2MSFTNGP04.phx.gbl...
>
|||Andrew J. Kelly wrote:
> I don't see the distinction for this. It is just a property (CommandTimeOut)
> that you set for the connection. It should not matter what the client or the
> server is or what they do.
>
The article he pointed you to does indeed describe how to use the
ConnectionTimeout property of the ADODB.Connection object, which is
similar to what you want.
If you are using the SqlConnection object on .NET 2.0 you'll notice that
the ConnectionTimeout property is readonly. What you need to do is
include the connection timeout in the connection string.
"Data Source=SERVERNAME;Initial Catalog=DBNAME;Integrated
Security=SSPI;Connect Timeout=5"
which will give you a 5 second timeout on the connection.
Arild
|||I guess anything is possible but this is a property of the connection so I
highly doubt it. Are you sure it is using the connection you think? Make
sure there isn't code somewhere that is either creating another or new
connection or overriding the settings.
Andrew J. Kelly SQL MVP
"tc" <tull@.idcodeware.co.uk> wrote in message
news:%23Hc3uFH0HHA.4928@.TK2MSFTNGP05.phx.gbl...
> It looked so promising!
> Is there any chance that the timeout parameter is ignored in the Compact
> Framework? I've tried all settings between 5 and 20 seconds, but the
> portable still sits there for 90.
> Any ideas?
> "Arild Bakken" <arild.bakken@.telecomputing.no> wrote in message
> news:%23Cq5Jm2zHHA.4476@.TK2MSFTNGP06.phx.gbl...
>