Solved

SQL compact edition 3.5 in VS

Posted on 2014-02-10
2
236 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
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now