Saturday, March 03, 2012 8:42 PM
is it supported to open a SQL Server Compact Edition 4.0 file from a network share? I read elsewhere that this is supported when you open the database in "exclusive" mode:
"The ability to open a file on a network share in an exclusive mode is a feature for SQL Server Compact 4.0."
However this does not work and I get the error message:
Internal error: Cannot open the shared memory region.
Saturday, March 03, 2012 9:14 PMModeratorIf you neerd to access a database across a network, you should use SQL Server (Express). I am not sure that the information in the connect comment reflects the actual implementation, which is that network access is not supported.
Please mark as answer, if this was it. Visit my SQL Server Compact blog
Sunday, March 04, 2012 10:05 AM
Is there an official document from Microsoft that states that opening from a network share is not supported?
When I open the sdf file from a Windows XP machine with a network share, it works....