Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > BOOK: Silverlight 4 Problem - Design - Solution
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Silverlight 4 Problem - Design - Solution
This is the forum to discuss the Wrox book Silverlight 4 Problem - Design - Solution by Nick Lecrenski; ISBN: 9780470534045
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Silverlight 4 Problem - Design - Solution section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 13th, 2010, 09:38 AM
Registered User
 
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default fix database file problem

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
Reply With Quote
  #2 (permalink)  
Old June 13th, 2010, 09:35 PM
Registered User
 
Join Date: Jun 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old June 13th, 2010, 11:14 PM
Registered User
 
Join Date: Jun 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #4 (permalink)  
Old June 16th, 2010, 05:54 PM
Registered User
 
Join Date: Jun 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Database problem

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.
Reply With Quote
  #5 (permalink)  
Old June 18th, 2010, 09:25 PM
Registered User
 
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Version Problem

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
Reply With Quote
  #6 (permalink)  
Old July 8th, 2010, 12:36 PM
Authorized User
 
Join Date: Dec 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default .

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)
Reply With Quote
  #7 (permalink)  
Old July 19th, 2010, 02:41 PM
Registered User
Points: 34, Level: 1
Points: 34, Level: 1 Points: 34, Level: 1 Points: 34, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #8 (permalink)  
Old July 27th, 2010, 04:16 PM
Registered User
 
Join Date: Jul 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default MDF 661 version 655 and earlier

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 "
Reply With Quote
  #9 (permalink)  
Old July 29th, 2010, 09:30 AM
Wrox Author
 
Join Date: May 2009
Posts: 13
Thanks: 0
Thanked 2 Times in 2 Posts
Default Working on a solution

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
Reply With Quote
  #10 (permalink)  
Old July 29th, 2010, 10:52 AM
Registered User
 
Join Date: Jun 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Frustration with Wrox and the 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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
File Downloads - Fix in Progress Teresa BOOK: Access 2003 VBA Programmer's Reference 0 June 7th, 2006 01:23 PM
Session Reuse Problem-- How to Fix CAHyatt Classic ASP Basics 5 June 1st, 2005 07:04 PM
Problem in making database file address virtual akhilvira ASP.NET 1.0 and 1.1 Basics 0 January 4th, 2005 12:33 AM
ASP Database Connection-File permission problem goljazoran Classic ASP Databases 4 November 29th, 2003 04:09 PM
ASP Database Connection-File permission problem goljazoran BOOK: Beginning ASP 3.0 0 November 10th, 2003 09:09 AM



All times are GMT -4. The time now is 03:24 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.