Can I create and connect to a SQL Server CE database if SQL Server 2005 isn't installed?
        Posted  
        
            by MusiGenesis
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by MusiGenesis
        
        
        
        Published on 2010-04-30T15:07:14Z
        Indexed on 
            2010/04/30
            15:37 UTC
        
        
        Read the original article
        Hit count: 283
        
Is there any way to do this?
Update:  Sorry, I should have included more information.  I am trying to create and connect to a SQL CE database using System.Data.SqlServerCe in C# running on a PC (i.e. not running on a Windows Mobile device).
This code:
string connstr = "Data Source=\"" + 
    filename + "\";Persist Security Info=False;";
System.Data.SqlServerCe.SqlCeEngine engine = new SqlCeEngine(connstr);
engine.CreateDatabase();
... works fine on any PC that has SQL Server 2005 installed, but fails on any PC that doesn't have it installed. I'm trying to find out if there's any way to get this to work without installed SQL Server 2005 on the machine.
© Stack Overflow or respective owner