InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:11:55 GMT20http://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxI have to admit I wasn't aware of that.. I assume you are basing that on this statement: "SQL Server Management Studio 2005 can read and modify CE 3.0 and 3.1 database files (with the latest service pack), but SQL Server Management Studio 2008 (or later) is required to read version 3.5 files. Microsoft Visual Studio Express 2008 SP1 can create, modify and query CE 3.5 SP1 database files."At: http://en.wikipedia.org/wiki/SQL_Server_CompactIt sounds like the management tools are.. I have to say I think that VS2005 is probably not compatible.. Sorry man..CEWIISun, 25 Oct 2009 19:55:32 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxok, 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?Sat, 24 Oct 2009 10:58:10 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxI'm sorry, I think you have done everything I would have done.. There is nothing else that would be obvious.. Sorry man..CEWIIFri, 23 Oct 2009 08:39:17 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxtried every SP1, there is1) Visual Studio 2008 SP1 - already installed , re-installed on top2) Microsoft SQL Server Compact 3.5 Service Pack 1 and Synchronization Services for ADO.NET version 1.0 Service Pack 1 for Windows Desktopalready installed - repaired on top3) Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobilealready installed4) Microsoft SQL Server Compact 3.5 Service Pack 1 Server Toolsre-installed / repairedFri, 23 Oct 2009 07:42:52 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxHow about the SP1?CEWIIThu, 22 Oct 2009 08:26:21 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxwhen 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".Thu, 22 Oct 2009 08:19:32 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxI have a thought.. Go to the SQL Server Compact Downloads page:http://www.microsoft.com/Sqlserver/2005/en/us/compact-downloads.aspxAnd download the version and all the tools there. Install them directly.That is about all I got..CEWIIThu, 22 Oct 2009 07:44:51 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxIt'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?Thu, 22 Oct 2009 06:17:44 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxSorry, I switched apps on you.. Aren't you psychic? That was in VS 2008 that I was talking..CEWIIWed, 21 Oct 2009 07:37:50 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxI don't see those options under view, in SQL Server Management Studio?Wed, 21 Oct 2009 02:18:21 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxWhat do you see from View|Database Explorer|Right click Data Connections|Add ConnectionI see:Microsoft Access Database FileMicrosoft SQL Server Compact 3.5Microsoft SQL Server Database FileWhat about you?CEWIITue, 20 Oct 2009 11:33:39 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxyes, I canTue, 20 Oct 2009 10:05:15 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxNo, from within SQL Server Management Studio, when you try to connect so you see "SQL Server compact Edition?"CEWIITue, 20 Oct 2009 09:52:13 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxHi,thanks for the early response. I have "Microsoft SQL Server 2005 Mobile Edition" and "Microsoft SQL Server Compact 3.5"under start -> All programsIs that what you meant?Tue, 20 Oct 2009 04:54:21 GMTericvanderhousenhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxDo you have the compact database option from the SS 2005 tools? CEWIITue, 20 Oct 2009 04:44:51 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic805575-137-1.aspxhi,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?regardsTue, 20 Oct 2009 04:43:27 GMTericvanderhousen