At 09:55 PM 23/11/2005 +0000, you wrote:

>Hi,
>
>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
>it?
>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
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
You'll probably have to add the key if you have never configured TCP/IP
manually before.


TcpNumConnections
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:

http://support.microsoft.com/default.aspx?scid=kb;en-us;314053

./helen