Wrox Programmer Forums
|
BOOK: Beginning ASP.NET Databases Also see the forum ASP Databases for more general discussions of ASP database issues not directly related to these books.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET Databases 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 January 17th, 2007, 02:42 AM
Registered User
 
Join Date: Jan 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Service Unavailable

Trying to run the very first example on pages 66 and 67 and when I enter the address to the local host I get a message in the web page "Service Unavailable". The book really doesn't explain what the environment setup particulars are. I must have something missing, but no clue as to what it is. I've searche dthe forum here, but didn't find a similar topic. I'm running SQL Server 2000 Std Edition Sp1 on Windows Server 2003 Std Ed Sp1.

 
Old January 17th, 2007, 08:55 AM
Friend of Wrox
 
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

rdomo: If I understand correctly, you are trying to execute the example in Chapter 3 Connecting to the Data Source in the ASP.NET Databases Usng VB.NET, correct? There are many things occuring on the two pages:
 1-creating the virtual directory, BegASPNETdb, for the sample code;
 2-creation and location of the web.config. NOTE: when editing the web.config, if using notepad, make sure the file extension is NOT changed to ".txt". Also note the location of the web.config in the name of your webroot-folder. Most common is "wwwroot" in the Inetpub subdirectory;
 3-Pay close attention to the Services for the MSDE, which may be where you are getting your error. Verify the strConnection pointing to the server and check Administrative Tools via the Control Panel to name of SQL Server is it (local) or localhost:8080;
 4- Verify that the Northwind SQL Db is in the correct directory or subdirectory.

Are you using the Web Matrix to execute the code?

It sounds as if it cannot find the SQL Server. I do know that it sample
works once you clear the annoying bugs.

Hope this helps.
 
Old January 19th, 2007, 02:51 AM
Registered User
 
Join Date: Jan 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the suggestions. I think it turned out to be something related to IIS and the .NET Framework. Evidently, IIS needs to be installed before .NET and I may have done it the other way around. It works now. I just wish the book would have devoted some more print to setting up the IIS and .NET environments for us beginners.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Server Application Unavailable td_ma ASP.NET 1.0 and 1.1 Basics 0 October 27th, 2008 03:15 AM
Service Unavailable i_shahid Classic ASP Professional 0 September 9th, 2008 03:49 AM
http/1.0 503 service unavailable Lyn ASP.NET 1.0 and 1.1 Professional 1 September 22nd, 2006 07:32 AM
IIS Service Unavailable -- >.aspx not recognized [email protected] ASP.NET 1.0 and 1.1 Professional 3 August 9th, 2006 10:38 AM
Servlet 'Start' is currently unavailable k209310 Servlets 1 August 26th, 2004 10:57 PM





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