It sounds like connection pooling is being used such as odbc, keeping 5
connections open for reuse.
To avoid this, you must change the connection string to contain something new.
This avoids the connection pooling process.
Example adding something as simple as time with seconds to a connection string
bypasses the connection pool process strictly because the connection string is
recongnized as new and not in the current connection pool.
In odbc I used a connection string parameter that is simply ignored such as
mytime=hhmmss
Sent from Yahoo Mail for iPhone
On Tuesday, December 31, 2019, 6:40 AM, Nagy Szilveszter
nagy_szilvesz...@yahoo.com [firebird-support]
<firebird-support@yahoogroups.com> wrote:
Hi all!
Is there a way to set connection timeout for firebird at client side?
The default value is somewhere around 50 seconds and if i have wrong IP address
set up in connection parameters then the application will freeze for almost a
minute before it gives an error message that it couldn't connect. I'd like to
reduce this waiting time to 5 seconds.
At server side there is a ConnectionTimeout parameter, but it does not help me
in this case (when i try to connect to an inexistent server, caused by wrong
configuration).
In real world example i have 2 servers configurations in a priority list (the
development server and the production one). The production server is the
highest priority one, so my clients have quick connection when they use the
application.
But when i'm in development environment (where the production server is not
reachable) the application would first try the prod server then after failing
it will try next server and my connection takes about a minute. I'd like this
to be 5 seconds or less.
(I know i could create connection definition files on each computer and rely on
those files - but that would bring more administration issues which i don't
want for this simple app)
Can you help me?
Thank you and have a happy new year! #yiv3450127990 #yiv3450127990 --
#yiv3450127990ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv3450127990 #yiv3450127990ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990ads
{margin-bottom:10px;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad
{padding:0 0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad p
{margin:0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad a
{color:#0000ff;text-decoration:none;}#yiv3450127990 #yiv3450127990ygrp-sponsor
#yiv3450127990ygrp-lc {font-family:Arial;}#yiv3450127990
#yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc #yiv3450127990hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3450127990
#yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc .yiv3450127990ad
{margin-bottom:10px;padding:0 0;}#yiv3450127990 #yiv3450127990actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3450127990
#yiv3450127990activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3450127990
#yiv3450127990activity span {font-weight:700;}#yiv3450127990
#yiv3450127990activity span:first-child
{text-transform:uppercase;}#yiv3450127990 #yiv3450127990activity span a
{color:#5085b6;text-decoration:none;}#yiv3450127990 #yiv3450127990activity span
span {color:#ff7900;}#yiv3450127990 #yiv3450127990activity span
.yiv3450127990underline {text-decoration:underline;}#yiv3450127990
.yiv3450127990attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3450127990 .yiv3450127990attach div a
{text-decoration:none;}#yiv3450127990 .yiv3450127990attach img
{border:none;padding-right:5px;}#yiv3450127990 .yiv3450127990attach label
{display:block;margin-bottom:5px;}#yiv3450127990 .yiv3450127990attach label a
{text-decoration:none;}#yiv3450127990 blockquote {margin:0 0 0
4px;}#yiv3450127990 .yiv3450127990bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3450127990
.yiv3450127990bold a {text-decoration:none;}#yiv3450127990 dd.yiv3450127990last
p a {font-family:Verdana;font-weight:700;}#yiv3450127990 dd.yiv3450127990last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3450127990
dd.yiv3450127990last p span.yiv3450127990yshortcuts
{margin-right:0;}#yiv3450127990 div.yiv3450127990attach-table div div a
{text-decoration:none;}#yiv3450127990 div.yiv3450127990attach-table
{width:400px;}#yiv3450127990 div..yiv3450127990file-title a, #yiv3450127990
div.yiv3450127990file-title a:active, #yiv3450127990
div.yiv3450127990file-title a:hover, #yiv3450127990 div.yiv3450127990file-title
a:visited {text-decoration:none;}#yiv3450127990 div.yiv3450127990photo-title a,
#yiv3450127990 div.yiv3450127990photo-title a:active, #yiv3450127990
div.yiv3450127990photo-title a:hover, #yiv3450127990
div.yiv3450127990photo-title a:visited {text-decoration:none;}#yiv3450127990
div#yiv3450127990ygrp-mlmsg #yiv3450127990ygrp-msg p a
span.yiv3450127990yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3450127990
.yiv3450127990green {color:#628c2a;}#yiv3450127990 .yiv3450127990MsoNormal
{margin:0 0 0 0;}#yiv3450127990 o {font-size:0;}#yiv3450127990
#yiv3450127990photos div {float:left;width:72px;}#yiv3450127990
#yiv3450127990photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3450127990
#yiv3450127990photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3450127990
#yiv3450127990reco-category {font-size:77%;}#yiv3450127990
#yiv3450127990reco-desc {font-size:77%;}#yiv3450127990 .yiv3450127990replbq
{margin:4px;}#yiv3450127990 #yiv3450127990ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3450127990 #yiv3450127990ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3450127990
#yiv3450127990ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3450127990
#yiv3450127990ygrp-mlmsg select, #yiv3450127990 input, #yiv3450127990 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3450127990
#yiv3450127990ygrp-mlmsg pre, #yiv3450127990 code {font:115%
monospace;}#yiv3450127990 #yiv3450127990ygrp-mlmsg *
{line-height:1.22em;}#yiv3450127990 #yiv3450127990ygrp-mlmsg #yiv3450127990logo
{padding-bottom:10px;}#yiv3450127990 #yiv3450127990ygrp-msg p a
{font-family:Verdana;}#yiv3450127990 #yiv3450127990ygrp-msg
p#yiv3450127990attach-count span {color:#1E66AE;font-weight:700;}#yiv3450127990
#yiv3450127990ygrp-reco #yiv3450127990reco-head
{color:#ff7900;font-weight:700;}#yiv3450127990 #yiv3450127990ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3450127990 #yiv3450127990ygrp-sponsor
#yiv3450127990ov li a {font-size:130%;text-decoration:none;}#yiv3450127990
#yiv3450127990ygrp-sponsor #yiv3450127990ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3450127990
#yiv3450127990ygrp-sponsor #yiv3450127990ov ul {margin:0;padding:0 0 0
8px;}#yiv3450127990 #yiv3450127990ygrp-text
{font-family:Georgia;}#yiv3450127990 #yiv3450127990ygrp-text p {margin:0 0 1em
0;}#yiv3450127990 #yiv3450127990ygrp-text tt {font-size:120%;}#yiv3450127990
#yiv3450127990ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3450127990
