Wrox Programmer Forums
|
BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2
This is the forum to discuss the Wrox book Professional ASP.NET 2.0 Server Control and Component Development by Dr. Shahram Khosravi; ISBN: 9780471793502
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 12th, 2007, 01:02 PM
Authorized User
 
Join Date: Sep 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sql 2000 version of Chp.12 databases

I currently do not have an sql server 2005 instance to attach the database files for Chapter 12, and I'm sysindexes table error messages when attempting to attach either the 'Chapter12DB1.mdf' OR 'Chapter12DB2.mdf' databases to my sql 2000 instance.

Are both of these .mdf files for sql 2005? If so, is there an sql 2000 alternative?

(Note that I cannot install sqlserver express 2005 on my machine)

 
Old March 23rd, 2007, 06:33 PM
Wrox Author
 
Join Date: Aug 2006
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Studen77,
Yes, both of these .mdf files are for SQL Server 2005. As the What You Need to Use This Book section of the book clearly states, you need to use either the full version of SQL Server 2005 or the SQL Server 2005 Express Edition, which is available as a free download from http://msdn.microsoft.com/sql/express/.

Cheers!
Shahram

-----------------------
Shahram Khosravi, Ph.D.
Author of Professional ASP.NET 2.0 Server Control and Component Development
 
Old December 2nd, 2015, 01:42 PM
Registered User
 
Join Date: Oct 2014
Posts: 9
Thanks: 2
Thanked 2 Times in 2 Posts
Default Another solution to the MDF problem

Quote:
Originally Posted by studen77 View Post
I currently do not have an sql server 2005 instance to attach the database files for Chapter 12, and I'm sysindexes table error messages when attempting to attach either the 'Chapter12DB1.mdf' OR 'Chapter12DB2.mdf' databases to my sql 2000 instance.

Are both of these .mdf files for sql 2005? If so, is there an sql 2000 alternative?

(Note that I cannot install sqlserver express 2005 on my machine)
It has been some time since you wrote this but incase you need an easier solution to opening the MDF files using a more advanced version of VS. All you need to do is delete the data connection to the db in the server Explorer and then click on Connect Database. Locate the MDF file and when a pop-up appears asking you if you want to update it just click Yes and you will now be connected.

The only additional change that you will have to make is if you are trying to connect to the aspnetdb.mdf file. in the web.config it uses ".\Express" for the source. unless you are using SQL Express this will have to be changed to the server you are using. In the case of VS2013 (with no SQL engine installed) it would read, "(LocalDB)\v11.0".

Mark





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chp.12 'custom' SqlDataSource and paging studen77 BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2 8 April 4th, 2007 05:49 PM
Chp.12 SqlDataSource.SelectCountCommand ??? studen77 BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2 4 March 7th, 2007 02:50 PM
Chp.12 SqlDataSourceView 'owner' property studen77 BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2 0 March 6th, 2007 02:58 PM
Getting Chatper 12 to work with Sql Server 2000 tperri75 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 11 August 11th, 2006 12:06 PM
Chp 12 - userviewer.php problems w/ hyperlinks jaymax BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 2 July 10th, 2003 04:54 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.