When I try to attach the "FitnessTrackerPlus.mdf" file to my SQL Server 2008 Express, I get an error message saying roughly this:

The database (long-winded database name) cannot be opened because it is version 661.

I suspect the database files were created for full-blown SQL Servers 2008, and hence cannot be attached to weaker/older versions of the SQL Server. I believe the vast majority of users/readers doesn't have the luxury of the full-blown SQL Server 2008.

Can anybody create and upload database files that can be attached to a run-of-the-mill Express version.

-- Kcin Lecrenski

Sorry, no help here, but you have my sympathy.

Can't attach to the DB either and I have the full version of SQL server 2008

OK my bad,
You need to have the R2 version of SQL express with advanced tools.
http://www.microsoft.com/express/Dat...llOptions.aspx

You also have to make sure you select the file properties of the database file and "Unblock" them.

It would be best to simply provide a script so those of us using real SQL can install it on our servers. I have followed all of the suggestions and still can't get this to work.

I don't have the R2 Version of Sql Server.

Will a script or another database be provided?

I don't think I'm going to upgrade over this book.

thanks,

T

I only have sql 2008 on my work comptuer

so i

1. Attached it to a sql2008R2 on my home comptuer
2. Create script for Sql 2008 with data and schema
3. Run that script on the Sql 2008 work computer...

Its mostly working.. im getting some problems.. not sure if iits related to the DB (going to post about that now)

Like others I bought the book but cannot open the database or run the samples. The fact that the database can't be opened using the software described in the "What You Need To Use This Book" is a huge oversight. Is anyone at Wrox doing something about this?

I just installed sql2008 enterprise

The revised code samples will not work, but the initial one's do .. who changed what, and how can I get the revised samples to work?

"MDF Cannot be opened because it is version 661. This server supports version 655 and earlier "

I am currently working on a solution to the problem. What happened was that I needed to revise the original code from the book in order to make everything work with the final Silverlight 4/RIA/Toolkit versions. Unfortunately I had already installed the R2 version of SQL Server 2008 Express.

It appears that the database is not backward compatible with previous versions of SQL Server Express.

I am currently working on providing create scripts as well as mdf files for the previous versions of SQL Express. I will post here again when it is available.

I apologize for the inconvenience!

Nick Lecrenski
Author

This book and the author have some excellent solutions which remain out of reach because Wrox and the author have been completely unresponsive over a long period of time to this issue. I have long been a proponent of Wrox books, but that is changing because of this.

The author should simply create a SQL script to create the database and post it so we can move forward with his book. It is a simple thing to do and I find it odd that he has not done so.

Gary