Subject Re: [firebird-support] Maximum number of sockets
Author Petr Hartman
----- Original Message -----
From: "Helen Borrie" <helebor@...>


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

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

Thanks, but this parameter seems not working for me. I tried to set TcpNumConnections 0, 20, 100 without any changes. Still maximum 64 connections. After setting this parameter I always restarted my computer.
Now I tried my test on my colleague's computer (WXP SP2, the same as the my one, FB 1.5.2) and it works. I am able to create for example 2000 connections.
I don't see any difference between these computers.

Regards,
Petr