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
Ginny Caughey MVP - 17 Jun 2008 11:50 GMT
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
>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
[quoted text clipped - 25 lines]
>
> Chris