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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

--

Ginny Caughey
Device Application Development MVP


"Anton" <anton@xxxxxxxxxxxxxxxxx> wrote in message news:eJk4QJ7AJHA.3168@xxxxxxxxxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • RE: SSIS Transfer object failure
    ... The problem is the "CopySchema" option it has to be set to ... a SQL Server 2005 SP1 database table to another database; ... I would like to let you know that though SQL Server ... 2005 SP1 has fixed many known issues, there are still some new discovered ...
    (microsoft.public.sqlserver.dts)
  • Re: Office 2007 Service Pack 1
    ... it appears the problem user does have Office 2007 SP1 installed. ... The last entry contains SP1 if it has the service pack. ... Perth, Western Australia ... an ACCDE copy of my Access 2007 database, ...
    (comp.databases.ms-access)
  • RE: Backup and Sharepoint
    ... it is recommended that apply the whole SBS SP1 to the SBS 2003 server ... However, Windows SP1 ... placed a database under Sharepoint where I told it to be created. ... When opening a new thread via the web interface, we recommend you check the ...
    (microsoft.public.windows.server.sbs)
  • Content Advisor and Database driven websites
    ... IE 6 SP1 ... Content Advisor when enabled causes database ... Example: Accessing OWA is fine. ... data transfer or remediate the issue (thus speeding up ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Cannot gain access to database
    ... SQL Server Developer Edition 2005 ... I went to SQL Management Studio Express and under Object Explorer I see the following items only: ... In the Databases, I created a new database 'videodb' and added some tables to this database. ...
    (microsoft.public.sqlserver.server)