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 July 7th, 2008, 09:48 AM
Registered User
 
Join Date: Jul 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 10: Appointment Booking System

The Appointment Booking System works fine on my local machine, but when I published our web server and run it. It keeps saying "This page cannot be found". I think it is related with database access. The first page is working fine, but when I try to login to the system, error comes up. Do you have any idea for that?
Is it port problem or database access problem?
Thank you so much,

Sam

 
Old July 7th, 2008, 02:22 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Is the server configured correctly and is ASP.NET supported?
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=369

Maybe the 404 refers to the genericError.htm, and thus hiding the real error? Temporarily, turn of customErrors in the web.config file.

Otherwise, can you post a live URL for me to look at? Or provide a bit more information about the actual error? E.g. the address in the address bar of your browser and so on?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old July 8th, 2008, 11:02 AM
Registered User
 
Join Date: Jul 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for reply.
Here is actual URL:

https://www.iaff.ttu.edu/AppointmentBooking/

When you sign in, the error will come up.
Thank you,

Sam

 
Old July 8th, 2008, 11:19 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Sam,

Have you looked at (and done something with) my suggestions from my previous post? Here's the error page I get:

https://www.iaff.ttu.edu/GenericErro...ng/SignUp.aspx

As you can see, it 404s on the generic error page.

Creating an account takes a long time (before the error comes up) so I guess the problem is related to database connectivity.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old July 8th, 2008, 03:14 PM
Registered User
 
Join Date: Jul 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for quick response.
I think the database problem. Is it port problem?
Do you have any idea?

Sam

 
Old July 8th, 2008, 03:28 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yes, I have. Like I said earlier: Temporarily, turn of customErrors in the web.config file.

Then you can see the real error....
 
Old July 9th, 2008, 09:19 AM
Registered User
 
Join Date: Jul 2008
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

<connectionStrings>
    <add name="AppointmentBooking" connectionString="Data Source=italy;Initial Catalog=ASPNETDB;Integrated Security=SSPI"/>

Our server name is italy, so I added like above, but it won't work.
Do you have any idea? I think we narrowed down the problem.
Thank you!

 
Old July 9th, 2008, 01:44 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Sam,

Take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

This is a situation I can't help much with other than provide this article. There are many reasons why it wouldn't work: the server is not named italy, it doesn't accept connections based on its name alone, it has a different instance name, it doesn't allow access to the user account used by the web server and so on.

You still haven't posted the real error message, so I can only guess. However, my article and your ISP should be able to help you figure this out.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old July 11th, 2008, 09:06 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Please read my previous posts; it's all in there.

The 404 error message is because the custom error page could not be found. As I said earlier, turn off customErrors in web.config so you can see the real database error. Right now, custom errors is hiding the real error.

I also told you how to add the databases in another thread: use the Attach command found in your database tools, whether they are for 2000 or 2005.

As I also said earlier: I can't help much with these kind of problems as I cannot see your setup. All I can tell you is where to look.

Your connectionstirng is probably fine; it's the SQL Server setup that needs attention. Read my articles so see how to configure databases, attache them, enable remote access and so on. It's all in there....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.
 
Old July 21st, 2008, 11:32 AM
Authorized User
 
Join Date: Jul 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar, This is the first time I am using the forum, so hope I am posting to the correct place.

I am extending the appointment booking system and as part of that need to display the list of all users so administrator can see, edit or remove them from the list, something like the page displayed by the ASP.NET Configuration. I can run the ASP.NET Configuration tool to get to a page i.e. http://localhost:1725/asp.netwebadmi...nageUsers.aspx

where we can perform all required tasks but I need a similar page within the application when is published, practically I need to get hold of the code that generates above page, any Idea?

PS. Thanks for the book which I find it very useful and to the point.







Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 10: Appointment Booking System shong BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 August 21st, 2008 04:04 AM
Appointment Booking KDSTECH BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 11 May 29th, 2008 12:46 AM
Appointment booking philblack1 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 5 January 25th, 2008 01:17 PM
Modifications in Appointment Booking System newbie07 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 July 18th, 2007 11:49 AM
Appointment Booking System newbie07 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 July 18th, 2007 08:32 AM





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