Referring to question How do I share a SQL Server CE database file (.sdf) for multiple processes?
According MSDN, SQL CE allows 256 concurrent connections to single database.
But even on the SAME machine, I facing sharing violation error when I open the same database BUT with 2 different process (a.exe & b.exe, code is the same). What seems to be the problem here?
I was using connection string
SqlCeConnection("Data Source=d:\test.sdf;Encrypt Database=True;Password=test;File Mode=read write;")