Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 12th, 2007, 02:02 PM
Authorized User
 
Join Date: Sep 2006
Location: , , .
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)

  #2 (permalink)  
Old March 23rd, 2007, 07:33 PM
Wrox Author
 
Join Date: Aug 2006
Location: , , .
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
  #3 (permalink)  
Old December 2nd, 2015, 01:42 PM
Registered User
Points: 55, Level: 1
Points: 55, Level: 1 Points: 55, Level: 1 Points: 55, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2014
Location: Colorado
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
 


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
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 06: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 01: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 05:54 PM



All times are GMT -4. The time now is 05:34 PM.


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