Sample Header Ad - 728x90

SQL Server CE 4.0 network share access

0 votes
1 answer
1556 views
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