Subject How can I increase the number of concurrent connections on FB Classic?
Author Subramaniam Aiylam

I am using Firebird Classic 1.5.2 on RedHat Linux in
a distributed environment, with multiple machines
accessing a Firebird database via JDBC.

As the number of machines on the network increase,
so do the number of active connections to the database
(each machine ends up with about 3-6 connections to
the database). When the total connection count (as
indicated by the fb_inet_server process) reaches
around 60, I start seeing failures making additional
connections. The error I get is:

SQL state [HY000]; error code [335544421]; Resource
Exception. connection rejected by remote interface,
error code: HY000

The firebird.log file contains entries that look

localhost.localdomain Sun Oct 30 23:49:21 2005
INET/inet_error: read errno = 104

I cannot see any configuration parameters in
firebird.conf that would address this. How can I
increase the limit of concurrent connections?

Any help will be greatly appreciated.
Thank you,

Yahoo! Mail - PC Magazine Editors' Choice 2005