I created a Db in Sql Server 2008R2, but I wanted to have it local, so I used the tool which a Member here recommended (ErikEJ) Primework Data Port Wizard.
Now I want to be able to connect to it locally, so I copied the new SDF in the project folder. I also followed the instructions on www.connectionstring.com on how to connect to a Sql CE DB by setting the |Data Directory=my path| and the porvider to Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5.
When I try to execute the program, I am not getting any error but the data is not showing up.
I know that I have Sql CE installed , because when I trying to connect to the same SDF via Sql Server, everything is fine.
What am I doing wrong??
Any help is highly appreciated!