I have SQL CE 3.0. I just opened up my 2005 Management Studio and connected to CE 3.0. You can see the status bar of the stuido below. The version towards the right shows the 3.0

  

 

 

 

Not sure why that particular key is not there.

 

Anyway, I have CE 3.5 as well. I will try the other key that you provided and see if that works.

 

Thanks,

Raj

 

You may have version 3.5 which has a corrosponding key of:

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC}

 

You need to find out which version of SQL CE you have and then find the key for that version. Then you use the same instructions for adding the "OLE DB Provider" key which would look like this for CE version 3.5:

 

 

 

and the new default string value for the key:

 

 

 

I just copied the same connection string given in the Developers guid and pasted into the Object Mapper and it said "Unable to connect".

 

When I tried to register "Microsoft SQL Server CE 3.0 OLE DB Provider for Windows" as per the instruction given in the guide, I couldn't find the key that that needs to be edited. This is the key that I need to edit as per the guide.

"[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945} "

 

I couldn't make the Object Mapper both manually as well as through Data Link connect to the CE database.

 

 

In the Developers Guide installed with DevForce, you will find complete information regarding SQL Server CE in Chapter 4 : Appendix.
I have included the relevant portion in the attached Word document above. There are also some links with information regarding issues with SQL CE from previous support questions:

DevForce will support any provider supported by the Entity Framework.  I did google a bit to see if there are known issues with SQL CE and EF, and found a few things relating to the machine.config or app.config, which I’ve linked below.  The first link also indicates that SQL CE SP1 is required.

 

Thanks,

Raj