CODEWITHSUNDEEP
sql-server-cewindows-mobile-6.5intermec
user619891
user619891

Reputation:

Can not connect to sdf file in sql server management studio on windows mobile 6.5.3 device

I am trying to connect to a sdf file on a Intermec Windows Mobile 6.5.3 device. The handheld is using SQL Server Compact 3.5. My PC has SQL Server 2008 R2 installed. I am able to connect, through SQL Server 2008 Management Studio, to a sdf file if I copy it from the handheld onto my computer. However, when I try connecting to the sdf file on the handheld I get the following error message from studio management.

Cannot connect to Mobile Device\Program Files\app\Data\app.sdf.
Additional information:
    Unable to configure ActiveSync for use with this application. 
    You don't have the required privileges on this machine to complete this
    operation. Contact your machine administrator for assistance. 
    (SQL Server Compact ADO.NET Data Provider)

One of our older applications used SQL Server Compact 3.0 and I was able to connect to the sdf file on the handheld through SQL Server 2005 Management Studio.

Anyone have any ideas?

Upvotes: 0

Views: 2157

Answers (2)

A.Rashid
A.Rashid

Reputation: 11

  1. first check Your Active Sync. you can see your WM Application
  2. Mobile Device-StorageCard-ProgrammeFiles-project.exe Put Manually here your .sdf file
  3. give this path for your connection string

SqlCeConnection cn = new SqlCeConnection(@"Data Source=\Storage Card\Program Files\ProjectName\TestDatabase.sdf");

Upvotes: 1

ErikEJ
ErikEJ

Reputation: 41749

Run SQL Server Management Studio as an administrator

Upvotes: 0

Related Questions