Subject Re: [firebird-support] Maximum number of sockets
Author Helen Borrie
At 09:55 PM 23/11/2005 +0000, you wrote:
>I am able to create only 63 concurrent connections to database. When I
>try to create another connection, I get this error in firebird.log:
>HOMEPC (Server) Wed Nov 23 21:46:37 2005
> INET/select_wait: select failed, errno = 0
>HOMEPC (Server) Wed Nov 23 21:46:37 2005
> SRVR_multi_thread/RECEIVE: error on main_port, shutting down
>and firebird freezes. I have to restart Firebird Server service.
>Is there really so low limit of concurrent connections? Can I increase
>I tried this test on W98, WXP, W2003 with FB 1.0, 1.5, 2.0, with the
>same result.

It's a Windows Registry setting that you have to configure by editing the
registry (yea, Microsoft, don't tell 'em anything they don't need to know!)

The key is
You'll probably have to add the key if you have never configured TCP/IP
manually before.

Key: Tcpip\Parameters
Value Type: REG_DWORD - Number
Valid Range: 0 - 0xfffffe
Default: 0xfffffe
Description: This parameter limits the maximum number of connections that
TCP can have open at the same time.

To pre-empt the next TCP/IP configuration problem you encounter, grab this
MS support document:;en-us;314053