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
Shutdown firebird, copy the database to a new file copy.
Then start firebird and try the backup and restore process on the file copy..
Sent from Yahoo Mail for iPhone
On Tuesday, December 31, 2019, 12:29 PM, Hugo Eyng hugoe...@msn.com
[firebird-support] wrote:
Hello Alexey.
IBPump was
Hello Alexey.
IBPump was a good idea.
IBPump doesn´t recover the corrupted table but at least it is possible to
restore all others.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Alexey Kovyazin a...@ib-aid.com
Hello Mark.
Gfix didn´t work even using it as you explained.
Atenciosamente,
+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com em nome
de Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Enviado: sábado, 28 de dezembro de 2019 07:02
Para:
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
HiWhy "list(x.tbl2_pk_id)"?Result of list is a blob string with one single
value like '1,2,3' not a 3 records '1', '2', '3'.And using "in" is not a good
choice here. Change query to e.g. 'exists' or better some 'join'Regards,Karol
Bieniaszewski
null
On 2019-12-30 17:57, Germán Balbi bal...@yahoo.com [firebird-support]
wrote:
> Hi.
> I have this problem in FB 2.5
>
> with x as (
> SELECT *
> FROM tbl_x1
> JOIN tbl_fk1 ON cond_1
> WHERE cond_w1
> UNION
> SELECT *
> FROM tbl_x1
> JOIN tbl_fk1 ON cond_2
> WHERE cond_w2
> )
>
>
