What is the number of maximum concurrent connections for Sql CE 3.5?

I believe the information you are looking for is the SQL Server Edition Comparison.

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.

I don't see anything in that documentation that lists specifically the number of connections you can use. – ctacke Oct 27 '08 at 18:38 Updated, it is in the word doc! – Mitchel Sellers Oct 27 '08 at 19:37.

SQL Server Compact 3.5 supports multiple connections up to the 256 connection limit.(source).

I know that SQL CE 3.5 allows multiple concurrent connections from multiple processes (as opposed to earlier versions that allowed, but did not recommend, multiples from only one process). My guess is that it's resource limited, but I'm not certain. I actually have a call in to the SQLCE team directly to find out if there is a count limit on this (I'll post back when I get a reply, likely later today, though with PDC ongoing, it might be longer).

That said, I question why you would need to know this. How many connections are you trying to make? You should have at least 2 - it's recommended to always maintain 1 connection, even if it's a dummy that's never used, to keep the connection cached for performance reasons - but I've never done any implementation that had more than maybe 4 or 5 at any given time.

If you have more than that, you might need to rethink your architecture, or the app is more likely a candidate for a full-blown server product. Update I finally heard back from the team and they confirmed from the source code that the number is 25 "...since we are implementing it in C/C++, the counter starts from 0 and ends in 255. These are the number of parallel connections and not total connections.

For every open, the counter goes up by 1 and for every close it goes down by 1. If you have not closed, but just unreferenced close happens on Dispose.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.