Menu
as google does not deliver what i want to know, i try to ask stackoverflow :) what is the number of max concurrent connections to a sql ce 3.5 database? thanks j.
923
Simultaneous MySQL connection limits Each database user is limited to 38 simultaneous MySQL connections. This limitation helps to prevent overloading the MySQL server to the detriment of other sites hosted on the server.
The maximum number of connections across SQL Server versions and editions is 32,767. You can determine how many connections SQL Server currently has by looking at: SELECT ConnectionStatus = CASE WHEN dec. most_recent_sql_handle = 0x0 THEN 'Unused' ELSE 'Used' END , CASE WHEN des.
SQL Server allows a maximum of 32,767 user connections. Because user connections is a dynamic (self-configuring) option, SQL Server adjust the maximum number of user connections automatically as needed, up to the maximum value allowable.
Concurrent Connection: The maximum amount of simultaneous connections your server can handle.
SQL Server Compact 3.5 supports multiple connections up to the 256 connection limit.(source)
119
I believe the information you are looking for is the SQL Server Edition Comparison.
For standard Editions - Compare Features
For Compact Edition - Compare Features
Edit
Sorry, this Word Document is most likely what you need.
Edit again
The answer is 256 concurrent connections for Compact, unlimited for express. See table 1 in the linked word doc.
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
