Not able to add SQL Server Compact 4.0 table to dataset

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!
myesterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
myesterConnect With a Mentor Author Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
myesterAuthor Commented:
SQL Compact Database 4.0 is not compatible with Winforms. It works with web projects.
0
 
Kevin CrossChief Technology OfficerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.