[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Error viewing ASP page

I have an ASP page that runs a stored procudure (SQL 2008R2), its part of a web application.
When I connect from home using the domain name I get the error below. But if I login to the server and open the web application locally the page displays the information just fine.

Error:  500 Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.

All the other pages work fine and this page has the same connection strings, permissions, etc as all the others, there is nothing special about it, so I have no idea why I can't open it from anywhere other than the server itself.
0
Aleks
Asked:
Aleks
  • 5
  • 3
  • 2
  • +1
4 Solutions
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
turn off friendly error messages in IIS and it should give you a more detailed error message.
0
 
AleksAuthor Commented:
We tried that but we still get the same error  :$
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you may have friendly messages turned on in your browser, check that. in IE, go to Tools -> Options ->Advanced and uncheck the option
0
Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

 
Ryan ChongCommented:
When I connect from home using the domain name I get the error below. But if I login to the server and open the web application locally the page displays the information just fine.
can you explain more clearly how you do this? is the website in a domain that is accessible publicly? have you check your local environment and make sure it's connected to internet?
0
 
AleksAuthor Commented:
From inside or outside the server we access it by using the domain name. It's an intranet but can be accessed from outside or inside the server. Only this page seems not accesible from outside
0
 
Ryan ChongCommented:
ok, seems that only this page is not working well.

what web browser are you using?
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
What about friendly messages being displayed by the actual browser settings? If we can get the actual error message then it will be that much easier to diagnose.
0
 
Scott Fell, EE MVEDeveloperCommented:
Is this the only page that calls the database?

Try changing your database connection string to use locahost.  That would be the safest.  If you have to use the domain name, you will need to open up the port to sql server in your firewall.

Connection_String = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=DATABASE_NAME;User ID=USER_NAME;Password=ABC123"

Open in new window

0
 
AleksAuthor Commented:
It is using localhost as all the other pages. I also checked the friendly errors and it is turned off.  I still get this:

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.
0
 
AleksAuthor Commented:
The console does not display any errors either.
0
 
Scott Fell, EE MVEDeveloperCommented:
Another way to get the error is to add at the top of the page

On Error Resume Next

Open in new window


Then at the bottom of the page add

If err.number <> 0 then 
  Response.write(err.description)
End if

Open in new window

0
 
AleksAuthor Commented:
Client is out for a few days more. I will reopen if this happens again.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now