PhotosDB in Chap 11 of Book, ASP.NET Unleashed, good for SQL Server 2010 only?

Question

I am working on Chap 11 of the book, ASP.NET 4 Unleashed.  To create the smaple database PhotosDB, I tried to
attach the .mdf file included in the Chapter to my SQL Server database, but got an error message that the database
is not compatile with the version of the SQL Server. 

I am still using the SQL Server 2008.  Is the PhotosDB database of this ASP.NET 4 book good for SQL Server 2010 only?

---

Jeffrey

Answer 1

Thought that the PhotosDB database from ASP.NET 4 Unleashed is for SQL Server 2010 only,
I used the PhotosDB mdf file from the Book, ASP.NET 3.5 Unleashed.  Tried attaching .mdf file
to create new datase on SQl Server 2008, still got the same error -- Database 'C:\...PHOTOS.MDF'
cannot be upgraded because its non-release version (603) is not supported by this version of SQL Server.

Is this PhotosDB.mdf can be compatible with SQL Server 2005/2000 only????

---

Jeffrey

Answer 2

Hello Jeffrey,

First, there is no Version 2010 of SQL Server, only 2005, 2008 and 2008R2.

If the database is of version 2000/2005 then you can attach it to 2008/2008R2 without any problem.

Please refer to the book which version is required or ask the author. Otherwise please post the complete error message, not only some fragments.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 3

Cannot paste the Microsft SSMS error img here.

An exception occurred while executing a Transact-SQL statement or batch. Database 'C:\ASP.NET UNLEASHED 2.0\CHAPTER X - Using the GridView ControCODE\VBAPP_DATA\PHOTOSDB.MDF' cannot be upgraded because its non-release version (603) is not supported by this version of SQL Server......

I checked the App_Data code files for ASP.NET 3.5 and ASP.NET 4 Unleashed, the PhotosDB.mdf and PhotosDB_log.ldf are the same.  However, as shown above, the
PhotosDB seems to be from the old version of the Book, i.e. ASP.NET UNLEASHED 2.0.
Moreover, as you said, database of version 2000/2005 should be attached to 2008/2008R2 without any problem.

Maybe the PROBLEM is: cannot be upgraded because its non-release version (603) is not supported by this version of SQL Server.   Can we find another version of PhotosDB?

 

 

 

---

Jeffrey

Answer 4

Cannot paste the Microsft SSMS error img here.
.....
Maybe the PROBLEM is: cannot be upgraded because its non-release version (603) is not supported by this version of SQL Server.   Can we find another version of PhotosDB?

Hello Jeffrey,

You can copy & paste the error message. In the error dialog on the bottom left there are 2 small icons for this.

Anyway, yes, version 603 seems to be a very first beta version of SQL Server 2005 and indeed it's not possible to use databases of beta releases in a final version of SQL Server. You may visit the homepage of the publisher to see if there is an update of the database; I guess you are not the first with this problem.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 5

Thanks.  Visited the book home page of publisher website, but can not find information for updating the database.

http://www.informit.com/store/product.aspx?isbn=0672330113

 

---

Jeffrey

Answer 6

Did you get this issue sorted out?

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker