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.
So is it allowed to connect SQL Server CE 4.0 using OLE DB in network share?
Does it cause any other problem?