Can't connect to CE 3.5 SP1 Database from VS2008 Server Explorer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anton - 21 Aug 2008 18:20 GMT

Hi,

when I create a CE 3.5 SP1 Database with SQL Management Studio i can open the .sdf with the SQL Management Studio, but
there is an error if I try to connect from the VS 2008 SP1 Server Explorer (The error states that the db has been
created with an older version of SQL Server Compact).

When I create the CD 3.5 SP1 Database via the VS 2008 SP1 Server Explorer I can use the DB from within VS 2008, but
there is an error if I try to connect to the DB from SQL Management Studio (Error: you are trying to connect to an older
version of a SQL Server Mobile database. Execute compact and repair).

How can I use the .sdf file form both, VS 2008 and SQL Management Studio.

Im using SQL Server Compact 3.5 SP1, SQL Server Compact 3.5 SP1 Server Tools, VS 2008 SP1

Thanks,
Anton

Reply to this Message

Ginny Caughey MVP - 21 Aug 2008 18:42 GMT

Anton,

What version of SSMS are you using? I just tested this using VS 2008 sp1 and
SSMS 2008 RTM and had no problems creating a database in one tool and
opening it in another.

Signature

Ginny Caughey
Device Application Development MVP

> Hi,
>
[quoted text clipped - 16 lines]
> Thanks,
> Anton

Reply to this Message

Anton - 22 Aug 2008 07:50 GMT

Hi Ginny,

thanks for your answer.

I have installed MS SQL Server 2008 and now it is working. Before i have used SQL Management Studio from SQL Server 2005.

Anton

Ginny Caughey MVP schrieb:

> Anton,
>
> What version of SSMS are you using? I just tested this using VS 2008 sp1
> and SSMS 2008 RTM and had no problems creating a database in one tool
> and opening it in another.

Reply to this Message