October 20, 2009 at 4:43 am
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
October 20, 2009 at 4:44 am
Do you have the compact database option from the SS 2005 tools?
CEWII
October 20, 2009 at 4:54 am
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?
October 20, 2009 at 9:52 am
No, from within SQL Server Management Studio, when you try to connect so you see "SQL Server compact Edition?"
CEWII
October 20, 2009 at 10:05 am
yes, I can
October 20, 2009 at 11:33 am
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
October 21, 2009 at 2:18 am
I don't see those options under view, in SQL Server Management Studio?
October 21, 2009 at 7:37 am
Sorry, I switched apps on you.. Aren't you psychic? That was in VS 2008 that I was talking..
CEWII
October 22, 2009 at 6:17 am
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?
October 22, 2009 at 7:44 am
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
October 22, 2009 at 8:19 am
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".
October 22, 2009 at 8:26 am
How about the SP1?
CEWII
October 23, 2009 at 7:42 am
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
October 23, 2009 at 8:39 am
I'm sorry, I think you have done everything I would have done.. There is nothing else that would be obvious..
Sorry man..
CEWII
October 24, 2009 at 10:58 am
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 15 total)
You must be logged in to reply to this topic. Login to reply