Subject Re: [firebird-support] Pierre seriasly need Help with connection errors
Author Aage Johansen
Pierre Kellerman wrote:
> I have a program that run scripts on a database. it do this by
> connecting to the database starting a transaction executing the script
> then commiting, closing the database and then move on the the next
> script.
> This meen that there is a lot of connect and disconnect from the
> database.
> We have been doing this for some years now. lately I frequently get the
> following error.
> Unable to complete network request to host "".
> Failed to establish a connection.
> No connection could be made because the target machine actively refused
> it.
> ...
> I now have created a small sample application ther just commect and
> disconnect from the database in a fore loop a 1000 times. The first time
> it ran through for about 400 times and then fail with this scenario
> described above. now every time I run it it fail on try 26.

I still think it is network related. As a workaround you might catch the
failed login, wait a second and then retry. If it happens just a few times
(2-3 times out of 1000) the delay would hardly be noticeable.
Which version of Fb are you using?

Aage J.