[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL compact edition 3.5 in VS

Posted on 2014-02-10
2
Medium Priority
?
245 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 2000 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

649 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