Accessing mobile DB from desktop application over ActiveSync connection

• office-746051

  SSC Enthusiast

  Points: 146

  More actions

  November 24, 2008 at 9:34 am

  #194399

  Hi,

  We are going to change database contents of a Windows Mobile from a Desktop PC connected over ActiveSync.

  On the mobile is a MS SQL CE 3.5 SP1 DB located. We would like to write and read some datas with a running Windows application on the desktop.

  This should be possible: With SQL Server Manager Studio 2008 we are able to connect to the mobile database and modify data contents.

  We succesfully connected to a DB of the desktop with an OLE DB connection string:

  Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Source=C:\test.sdf

  The connection with

  Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Source=Mobile Device\Program Files\test.sdf

  didn't work.

  Best Regards:

  Lesley

• Abhishek-417518

  Valued Member

  Points: 59

  More actions

  June 3, 2010 at 12:48 am

  #1175715

  Hi,

  If your desktop application is built in .NET then try with using Namespace Microsoft.SqlServerCe.Client instead of System.Data.SqlServerCe.

  Hope it will work.