Solved

SQL compact edition 3.5 in VS

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with exporting to excel 4 26
Need some help to cast ntext to nvarchar SQL 2000 7 31
Can > be used for a Text field 6 39
Show Results for Latest DateTime in a View 27 24
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

776 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