Showing posts with label attempt. Show all posts
Showing posts with label attempt. Show all posts

Sunday, March 25, 2012

Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.

Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.