Connection String to a Local SDF File


  • HI,

    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 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!


    Abe Perl
    Monday, May 30, 2011 10:53 PM


  • Ok meanwhile I figured already, the issue was that I had a few connection strings in the project, and I connected to a blank connection string.....a Newbie issue...


    Abe Perl
    • Marked as answer by Abe Perl Tuesday, May 31, 2011 9:26 PM
    Tuesday, May 31, 2011 9:26 PM