Can't open SSCE 3.5 DB in SSMS   

I have been using SSCE 3.5 in an application I am developing since it 
was released, but have not needed to connect to connect to it with SSMS 
until now, and I was surprised to find I was unable to do this. It 
worked fine back when I was using 3.1, but now it appears to be 
attempting to open the database using the 3.1 libs.

In the 'Server type' dropdown list I select 'SQL Server Compact 
Edition'. The DB is not encrypted and does not have a passord.
I get the following error when I click 'Connect':

Cannot connect to 
C:\Users\Chris\AppData\Local\MYAPP\Users\chris\Data\MYDB.sdf.

------------------------------
ADDITIONAL INFORMATION:

You are trying to access an older version of a SQL Server Compact 
Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run 
upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later 
database, run Compact / Repair. [ Db version = 3505053,Requested version 
= 3004180,File name = 
C:\Users\Chris\AppData\Local\MYAPP\Users\chris\Data\MYDB.sdf ] (SQL 
Server Compact Edition ADO.NET Data Provider)



3.1 had an SDK available, but I cannot find an equivalent for 3.5.
I do have VS 2008, if that is relevant.

Any help would be appreciated. Thanks,


Chris

date: Mon, 16 Jun 2008 19:38:30 -0600   author:   Chris

Re: Can't open SSCE 3.5 DB in SSMS   

Chris,

You can use SSMS from SQL 2008 to open SSCE 3.5 databases but not SSMS from 
SQL 2005. You can also use Visual Studio 2008 to open SSCE 3.5 databases.

Ginny Caughey
Device Application Development MVP

"Chris"  wrote in message 
news:%23Z2yQrB0IHA.3504@TK2MSFTNGP06.phx.gbl...
>I have been using SSCE 3.5 in an application I am developing since it was 
>released, but have not needed to connect to connect to it with SSMS until 
>now, and I was surprised to find I was unable to do this. It worked fine 
>back when I was using 3.1, but now it appears to be attempting to open the 
>database using the 3.1 libs.
>
> In the 'Server type' dropdown list I select 'SQL Server Compact Edition'. 
> The DB is not encrypted and does not have a passord.
> I get the following error when I click 'Connect':
>
> Cannot connect to 
> C:\Users\Chris\AppData\Local\MYAPP\Users\chris\Data\MYDB.sdf.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> You are trying to access an older version of a SQL Server Compact Edition 
> database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. 
> If this is a SQL Server Compact Edition 3.0 or later database, run Compact 
> / Repair. [ Db version = 3505053,Requested version = 3004180,File name = 
> C:\Users\Chris\AppData\Local\MYAPP\Users\chris\Data\MYDB.sdf ] (SQL Server 
> Compact Edition ADO.NET Data Provider)
>
>
>
> 3.1 had an SDK available, but I cannot find an equivalent for 3.5.
> I do have VS 2008, if that is relevant.
>
> Any help would be appreciated. Thanks,
>
>
> Chris

date: Tue, 17 Jun 2008 06:50:25 -0400   author:   Ginny Caughey MVP