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

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.

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

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.

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

Sam

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

Then you can see the real error....

<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!

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.

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.

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.