Wrox Programmer Forums
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 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 May 2nd, 2006, 03:47 AM
Authorized User
Join Date: Mar 2006
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL2005 to SQL2000 issue

Hi Imar,

Let me point out a major problem for all users. First of all sql2005 and express are just new so every hosting company does not support it currently. Next since sql expresss is totally FREE, every hosting company avoids this ( since they cannot charge ).No hosting support is found for sqlexpress.

The last option left is sql2000 which every hosting company supports, since its already there since long time.

What you should be doing is providing sql2000 database support as well as a seperate download, which is finally used as placing the site online. The developers/students like me can study on sql2005 express and take all trials locally, but finally when they need to go online none of the database/stored procedures are useful, since there is no sql2005 support found everywhere.

MicroSoft- also provides sql2000 with all starterkits, since they are aware of this. We request you to do so. The fresh developers/students are in no condition to create the highly advanced storeproceures so quickly and without any error. All thy can do is run aspnet regsql and create aspnetdb.

sql2000 database ( seperate download ) is the only way to go online.

Pl. guide me if i am wrong in any way.


Old May 2nd, 2006, 08:40 AM
jminatel's Avatar
Wrox Staff
Points: 18,059, Level: 58
Points: 18,059, Level: 58 Points: 18,059, Level: 58 Points: 18,059, Level: 58
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2003
Posts: 1,906
Thanks: 62
Thanked 139 Times in 101 Posts

SoftMind: You are right that not all of the hosters have upgraded to offer SQL Server 2005 Hosting. However, in designing this book, we went with 2005 for 2 reasons: One, SQL Server 2005 (whether Express or Standard) is really the preferred way to use ASP.NET 2.0. Yes, you can use SQL Server 2000 with it, but we expected more book readers to be going the route of using both new technologies together. 2nd, with the free availability of SQL Server 2005 Express Edition (a much better free option than MSDE was for the 2000 era SQL Server) we thought most readers would experiment with this locally using SQL Server 2005 Express.
The number of hosters working with ASP.NET 2.0 and SQL Server 2005 might vary by country and I haven't looked at Microsoft India's site to see if they have a similar list. Here in the US, MSFT has a list of ASP.NET 2.0 hosters:
SQL Server 2005 hosters:

It's fairly easy to look through the lists here and find a hoster supporting both and having a good deal. Granted, if you are happy with your hoster and don't want to switch but they don't offer the version support you need, that's another problem.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Jim's Book of the week: No book this week - Donate to the Red Cross!
Old May 2nd, 2006, 09:09 AM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

In addition to what Jim has mentioned, I'd like to point out that SQL Server 2005 is not just an increase in version number by 5... ;)

The book uses a number of new SQL Server 2005 features (like Common Table Expressions) that didn't exist in SQL 2000, so "downgrading" a site that uses this feature (the Customer Support Site for example) is not an easy undertaking.

Imar Spaanjaars
Everyone is unique, except for me.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Newby need to import Excel to SQL2005 TashaAT C# 2005 35 August 3rd, 2008 02:45 PM
Replication with SQL2005 seananderson Access 0 November 30th, 2007 05:32 AM
sql2005 management studio very slow lucycastaldo SQL Server 2005 0 November 22nd, 2007 06:41 PM
Add a 2'nd SQL2005 db ADH BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 August 25th, 2007 06:08 PM
dbo qualifier issue (sql2005 BE with Access FE) gvcooper SQL Server 2005 2 July 24th, 2006 01:13 AM

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