How many simultaneous connections can be made to a Firebird database server running on Windows XP Pro?

Asked Oct 03 '13 at 23:24

Active Mar 29 '21 at 17:55

Viewed 1,333 times

I have Firebird version 2.1 running as a database server on a Windows XP Pro machine.

There are 35 users on my network all using the same FB server. Though not all of them may connect simultaneously I'm pretty sure at least 20 do.

Why is this possible if there is a 10 session limit on Windows XP Pro?

I'd like more details to understand what is going on here?

edited Mar 29 '21 at 17:55

Mark Rotteveel

asked Oct 03 '13 at 23:24

Jonathan Elkins

1

In Firebird 2.1+ you can select * from mon$attachments to see who is connected. – nater Oct 04 '13 at 02:10
3

There is - AFAIK - no 10 session limit on Windows XP Pro, but there is a 10 **half-open** connection limit (although I believe they removed that in later versions or servicepacks), which means that on a non-server Windows there can be only 10 connections where the TCP/IP handshake hasn't been completed yet. There however is no (or at least a higher) connection limit for established connections. – Mark Rotteveel Oct 04 '13 at 08:02

0 Answers0