Solved

SQL compact edition 3.5 in VS

Posted on 2014-02-10
2
240 Views
Last Modified: 2014-02-17
Hi

I have VS 2005 on a Win7-64bit machine. I try to make connections to a SQL CE 3.5.
- SQL CE 3.5 is installed
- SP1 and SP for Vista installed

If I add a new connection I can not select SQL CE 3.5, only SQL Server 2005 CE. What can be wrong? Thanks, Peter
0
Comment
Question by:formi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 39848670
According to a comment found on the MSDN forum, you can use VS 2005 to interact with a SQLCE 3.5 database file, but you won't get any design-time support for your database files. If you want that, you will need to upgrade to a higher edition. Visual Studio 2010 Express is free, and it provides design-time support.
0
 

Author Closing Comment

by:formi
ID: 39865243
I downloaded VS 2010 express to manage/convert the database and develop with VS 2005. That's not really great but it works. Thanks!
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question