Solved

Not able to add SQL Server Compact 4.0 table to dataset

Posted on 2011-10-01
4
1,338 Views
Last Modified: 2013-11-17
I have a vb.net project in Visual Studio 2010 SP1 that uses SQL server compact 4.0 database. I recently upgraded the database from SQL server compact 3.5 to version 4.0. I changed the target framework to 4.0 in the project properties. Now when I try to drag a table from the database in Server Explorer to the dataset I get the following error:

 "The version of Microsoft SQL Server Compact database that you selected is not supported by the current project. The database and the connection will not be added to the project.".

Other than this the project builds okay and I can run it, but I can't add a table to the dataset.

Also, if I try to add a new Datasource SQL Server Compact 4.0 is not an option in the Data Source list, and in the Data Provider dropdown box the only option is ">NET Framework Data Provider for Microsoft SQL SErver Compact 3.5". There is no option for version 4.0.

Any help would be very much appreciated. Thanks!
0
Comment
Question by:myester
[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
  • 2
4 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36898375
HI. I just had the same experience with version 4. I believe what ultimately fixed it for me was that SP1 for VS2010 had to be reinstalled/repaired. Try that and post back.
0
 

Accepted Solution

by:
myester earned 0 total points
ID: 36902444
HI, from what I've been able to learn version 4 is not compatible with Winforms in Visual Studio. It only works with web projects.What type of project are you working with? Thanks!
0
 

Author Closing Comment

by:myester
ID: 36972661
SQL Compact Database 4.0 is not compatible with Winforms. It works with web projects.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36944789
Sorry I did not get a notification on your response. I was trying this in a general Library project as I wanted to use with both a WinForm and Web Application, so the DAL was common.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

732 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