Open SQLCE 4.0 Database from network share?
-
3. března 2012 20:42
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:
"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
Všechny reakce
-
3. března 2012 21:14Moderátor
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
- Navržen jako odpověď Peja TaoModerator 5. března 2012 7:50
- Zrušeno navržení jako odpověď Peja TaoModerator 5. března 2012 8:04
- Navržen jako odpověď Peja TaoModerator 5. března 2012 8:07
-
4. března 2012 10:05
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