[Moosipher]

Hi there.
I have searched these forums and googled for the last few days, and I'm getting nowhere. It seems this question has been asked here previously, but the asker did not appear to get an answer.
So you now have a new member

Problem - When debugging, I get the error message as in the screen shot.

When I run the program without debugging, I get the following .net framework error:

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. 

The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.

Can someone please let me know what to do to perform this upgrade? I'm unsure if I need to upgrade Visual Studio (2010 Express edition), upgrade part or all of the .net framework, or upgrade the database. I have no clue how to so any of the above, so a walkthrough would be great, if anyone can spare me the time. I really want to get stuck into this, as I have an idea for a project I want to try out, but getting stuck at the first practical hurdle is frustrating.

I would really welcome any input - like I said, I have looked through the book (second edition), searched google, searched MSDN, but not found an answer to this problem.

Thanks all

Attached thumbnail(s)

• 

This post has been edited by Moosipher: 11 March 2013 - 12:24 PM

[Sikta_26785]

Your google search skills need some work.

http://stackoverflow...l-server-ce-4-0

I found a number of different solutions that would fix this problem.

http://msdn.microsof...y/bb896150.aspx

[Moosipher]

Wow.

Thank you for the link. Also, thank you for the attitude. I'll be sure not to ask any more stupid questions.

- edit -

And, the solutions did not work - I still have the same problem. But as you have made me feel so welcome, I'll go somewhere else for help.

This post has been edited by Moosipher: 12 March 2013 - 03:01 AM

[Moosipher]

Apologies for my reaction. I do welcome the input, but I had already done as suggested, hence my somewhat verbose starting post, and I'm finding this increasingly frustrating. I do know how to use google, and MSDN, and had found the posts you indicated previously. I'm reading the first chapter in a beginning C# book - I do not have the knowledge I would need to enter this code - as I thought I had stated in my first post. Should I create another solution and somehow link it ? Should I just find somewhere in my code and slap that in? Should I edit the database file and enter that code somewhere?
I have tried the fixes mentioned in your links, as best I can, also tried deleting the database file and recreating it, tried opening it as a diferent type of DB, tried renaming it from within VS, and manually, but cannot get around this problem.
I'm now moving on through the book, as it seems that I simply won't be able to complete the first chapter. Annoying, as I would like to be able to reference databases. I would also like to have an answer of where I have gone wrong to be seeing this message, but neither your reply, nor the posts I have found have indicated where the problem is coming from.

This post has been edited by Moosipher: 12 March 2013 - 06:23 AM

[Sikta_26785]

If you can attach your solution, I'd be willing to take a look at it. I wasn't intending it to come off with attitude, should've tacked on a smiley I guess. From reading those posts, it sounds like the issue is when you downloaded VS 2010 express they have upgraded the ADO.Net connection to use .NET 4.0. But for some reason the template you use when creating the database is creating a .NET 3.5 database. Not sure why that would be but I think I could fix it if I had your solution. Although I think my ADO.Net connection is still using 3.5 because my database is definitely 3.5.

[Moosipher]

Phew. Right, I've solved that problem.
At some point last year I had (apparently) downloaded something from Visual Studio 2012, this had installed a new version of dsref80.dll to
C:\Program Files\Common Files\microsoft shared\Visual Database Tools. (I checked this by right clicking, going to properties, and looking at details. There was the product name 'Microsoft Visual Studio 2012' !!)
I deleted this, got hold of a version that was created with Visual Studio 2010 install, placed that file into the folder - now I can get past this point.
Thanks for your help and patience