Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 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 Search this Thread Display Modes
  #1 (permalink)  
Old July 7th, 2008, 09:48 AM
Registered User
 
Join Date: Jul 2008
Location: Lubbock, Texas, USA.
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

  #2 (permalink)  
Old July 7th, 2008, 02:22 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #3 (permalink)  
Old July 8th, 2008, 11:02 AM
Registered User
 
Join Date: Jul 2008
Location: Lubbock, Texas, USA.
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

  #4 (permalink)  
Old July 8th, 2008, 11:19 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #5 (permalink)  
Old July 8th, 2008, 03:14 PM
Registered User
 
Join Date: Jul 2008
Location: Lubbock, Texas, USA.
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

  #6 (permalink)  
Old July 8th, 2008, 03:28 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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....
  #7 (permalink)  
Old July 9th, 2008, 09:19 AM
Registered User
 
Join Date: Jul 2008
Location: Lubbock, Texas, USA.
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!

  #8 (permalink)  
Old July 9th, 2008, 01:44 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #9 (permalink)  
Old July 11th, 2008, 09:06 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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.
  #10 (permalink)  
Old July 21st, 2008, 11:32 AM
Authorized User
 
Join Date: Jul 2008
Location: , , .
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.


 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
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



All times are GMT -4. The time now is 11:15 AM.


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