Open SQLCE 4.0 Database from network share?

Question

Hi,

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:

See:

http://connect.microsoft.com/SQLServer/feedback/details/646333/sql-ce-4-0-no-longer-supports-opening-files-on-a-network-share

"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.

Thanks

Jus

Answer 1

If 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

Answer 2

Is there an official document from Microsoft that states that opening from a network share is not supported?

Strange side-note:

When I open the sdf file from a Windows XP machine with a network share, it works....

Jus