In our application we are planning to use SQL Server CE 4.0 using OLE DB. The connection string is shown below.
Dim strConn As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=\\pc137\d\desktop\mydb.sdf; SSCE:Database Password='password';"
Dim conn As New OleDbConnection
conn = New OleDbConnection(strConn)
conn.Open()
This one worked for both the local and network share files (
.sdf
)
We tried to connect using Visual Studio for the network share we get following error
> SQL Server Compact does not support opening database files on a network share.
We have referred this links
So is it allowed to connect SQL Server CE 4.0 using OLE DB in network share?
Does it cause any other problem?
Asked by IT researcher
(3178 rep)
Dec 17, 2014, 12:23 PM
Last activity: Dec 18, 2014, 12:01 PM
Last activity: Dec 18, 2014, 12:01 PM