Please help with install ( screwed up )

  • ericvanderhousen

    Old Hand

    Points: 370

    hi,

    Please help. I have Vista,Visual Studio 2008, SQL Server 2005. And various SPs. Installation screwed up.

    In Visual Studio 2008, if I go to:

    data -> add new data source -> database -> new connection

    I can't see the Microsoft SQL Server CE option?

    regards

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    Do you have the compact database option from the SS 2005 tools?

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    Hi,

    thanks for the early response. I have "Microsoft SQL Server 2005 Mobile Edition" and "Microsoft SQL Server Compact 3.5"under start -> All programs

    Is that what you meant?

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    No, from within SQL Server Management Studio, when you try to connect so you see "SQL Server compact Edition?"

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    yes, I can

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    What do you see from View|Database Explorer|Right click Data Connections|Add Connection

    I see:

    Microsoft Access Database File

    Microsoft SQL Server Compact 3.5

    Microsoft SQL Server Database File

    What about you?

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    I don't see those options under view, in SQL Server Management Studio?

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    Sorry, I switched apps on you.. Aren't you psychic? That was in VS 2008 that I was talking..

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    It's ok. I did also look in Visual Studio 2008, but, there is no

    Microsoft SQL Server Compact 3.5 ???

    I need to re-install something. I've been re-installing everything related, but, nothing yet?

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    I have a thought.. Go to the SQL Server Compact Downloads page:

    http://www.microsoft.com/Sqlserver/2005/en/us/compact-downloads.aspx

    And download the version and all the tools there. Install them directly.

    That is about all I got..

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    when i try and install, Microsoft SQL Server Compact 3.5 for Windows Mobile ( SSCEDeviceRuntime-ENU.msi ), i get the message , "a later version of microsoft sql server compact for devices is already installed".

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    How about the SP1?

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    tried every SP1, there is

    1) Visual Studio 2008 SP1 - already installed , re-installed on top

    2) Microsoft SQL Server Compact 3.5 Service Pack 1 and Synchronization Services for ADO.NET version 1.0 Service Pack 1 for Windows Desktop

    already installed - repaired on top

    3) Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile

    already installed

    4) Microsoft SQL Server Compact 3.5 Service Pack 1 Server Tools

    re-installed / repaired

  • Elliott Whitlow

    SSC Guru

    Points: 102296

    I'm sorry, I think you have done everything I would have done.. There is nothing else that would be obvious..

    Sorry man..

    CEWII

  • ericvanderhousen

    Old Hand

    Points: 370

    ok, one more thing, looking at wikipedia, it says "sql server 2005 is not compatible with SQL Server CE 3.5"??? Is that true?

    Question 2, are compatiblitlity issues only related between sql server 2005 and SQL Server CE 3.5, or are there also compatibility issues with Visual Studio 20008?

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply