search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
.NET Framework GroupsView
Deployment Server
.NET Distributed_Apps
.NET
.NET ADO.NET
.NET ASP.NET
.NET ASP.NET Security
.NET ASP.NET Webcontrols
.NET ASP.NET Web Services
.NET Clr
.NET Compact Framework
.NET Drawing
.NET Interop
.NET Micro Porting
.NET Performance
.NET Web Services
.NET Windows Forms
.NET Windows Forms Controls
.NET General
.NET Csharp
.NET Visual Basic
.NET Vc
.NET Security
.NET Xml
Scripting Jscript
Scripting Visual Basicscript
Scripting Wsh
Smartphone Developer
Visual Basic Com
Visual Basic Controls
Visual Basic Crystal
Visual Basic Database Ado
Visual Basic Syntax
Visual Basic Vista Compatibility
Visual Basic Winapi
Vc Atl
Vc Debugger
Vc Language
Vc Mfc
Vc Stl
Visio Developer Visual Basica
Vsnet Debugging
Windows Powershell
Windowsce Embedded Vc
Xml
Xsl

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Application Development
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft NET Compact Framework Posts  Ask A New Question 

SQLCE 3.5 and Management Studio 2005 - Christian Resma Helle

Monday, December 03, 2007 10:36 AM

Is it possible to use the SQL Server Management Studio 2005 for working with
SQLCE 3.5 databases? In the management studio default setup I get an error
when I tried to open a SQLCE 3.5 database.

Any of you guys got this to work or know a work around? I would prefer not
to install the SQL Server 2008 CTP :)

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com
reply
 

No, SSMS 2005 doesn't support SqlCE 3.5. - Ginny Caughey [MVP]

Monday, December 03, 2007 10:37 AM

No, SSMS 2005 does not support SqlCE 3.5. As an alternative to SQL 2008, VS
2008 data tools work with SqlCE 3.5.

--
Ginny Caughey
Device Application Development MVP
reply

That's true. I created the database in VS 2008. - Christian Resma Helle

Monday, December 03, 2007 10:47 AM

That's true. I created the database in VS 2008. I was just curious coz I
prefer using the management studio.

Thanks!

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com
reply

Christian,I prefer SSMS myself, so I certainly understand. - Ginny Caughey [MVP]

Monday, December 03, 2007 10:53 AM

Christian,

I prefer SSMS myself, so I certainly understand.

--
Ginny Caughey
Device Application Development MVP
reply

As an alternative you could use the "Data Port Console" from PrimeWorks. - ErikEJ

Monday, December 03, 2007 11:51 AM

As an alternative you could use the "Data Port Console" from PrimeWorks.

It works with version 3.1 and 3.5 on the desktop, and 2.0 and later on
devices.
Quite similar to SSMS, but more features: (Export, Import, Diagrams etc)

--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com
reply

Cool! I'll download the trial and see what it can offer! - Christian Resma Helle

Monday, December 03, 2007 1:50 PM

Cool! I will download the trial and see what it can offer! Do you use it
yourself?

--
Regards,
Christian Resma Helle
http://christian-helle.blogspot.com
reply

Yes, occasionally, in particular now that I have to work with both 3.0 and 3. - ErikE

Tuesday, December 04, 2007 8:02 AM

Yes, occasionally, in particular now that I have to work with both 3.0 and
3.5 file formats.
--
Erik Ejlskov Jensen - MCTS: Mobile App Dev
reply

Hi Ginny,I'm a total newbie regarding SqlCE. And I'm no SSMS expert neither. - Serge Wautier

Tuesday, January 08, 2008 5:33 AM

Hi Ginny,

I'm a total newbie regarding SqlCE. And I'm no SSMS expert neither.
I just installed SqlCE 3.5 on my dev machine. Opened SSMS 2005. Went to
Connect/Sql Server Mobile. Create a DB, created tables into it. Ran queries
against it. Everything worked like a charm.
... Except for one problem: There's no 'Open Table' menu item :-(

Do you have any explanation to offer as to why support seems complete at
first sight but oddly lacks the data grid, even though data queries work
fine.

TIA,

Serge.
http://www.apptranslator.com - Localization tool for your applications
reply

Serge,I don't know the inner workings of SSMS - only that the SSC team at - Ginny Caughey [MVP]

Tuesday, January 08, 2008 8:05 AM

Serge,

I don't know the inner workings of SSMS - only that the SSC team at
Microsoft has advised that SSMS 2008 is the target for support for SSC 3.5.
I assume the database you created with SSMS 2005 was a SSC 3.1 database.
There is no Open Table menu for SSC databases in SSMS 2005.

--
Ginny Caughey
Device Application Development MVP
reply

Ginny,Thanks for your answer.Actually, I thought I had created a SSC 3. - Serge Wautier

Tuesday, January 08, 2008 8:59 AM

Ginny,

Thanks for your answer.
Actually, I thought I had created a SSC 3.5 DB using SSMS 2005. But it
appears it's probably a 3.1 indeed: I tried to open the DB using PrimeWorks
Data Port Console and it complained. OTOH, I could not open a SSC 3.5 DB
created with Data Port Console using SSMS 2005.

Oh my, I guess I'll stick to Data Port Console or I'll take advantage of the
opportunity to install VS2008

Regards,

Serge.
http://www.apptranslator.com - Localization tool for your applications
reply

Previous Microsoft NET Compact Framework conversation.