Classic ASP Discussion - ASP sode showing in Browser error 500.100

Print Page | Close Window

ASP sode showing in Browser error 500.100

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9710
Printed Date: 31 March 2026 at 6:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP sode showing in Browser error 500.100

Posted By: neosarcastic
Subject: ASP sode showing in Browser error 500.100
Date Posted: 10 February 2004 at 4:05pm

I see alot of possible reason for this error but none seem to apply here. I am rebuilding a corporate intranet. ASP and SQL in dreamweaver mx. search pages are working fine and for myself and another IT staff member here the update, add and delete records pages are all working fine. I have restricted access to these pages by way of login.asp.

I went to test this on another user's pc. the search works fine but when i click on a page that requires a login (login.asp) I am seeing the code to an error page. reading the code i see it is a 500.100 error ASP and IIS. but thats all it gives me. (show friendly http error messages is not checked, although i have tried both)

Clearly this is a permission issue so i had a look on the IIS server at the login.asp that we have had in place on the exsisting intranet for years.-- There is no difference in permissions from the parent folder down. and both/all dialogues in IIS for the old intranet and the new are the same.

this staff member can access the old login.asp fine but not the new one i have created????

What am I misssing???

Tony

Replies:

Posted By: pmormr
Date Posted: 10 February 2004 at 7:23pm

are you accessing the page like this...

file://\\Confucius\mypage.asp - \\Confucius\mypage.asp

or like this...

http://www.mysite.com/mypage.asp - http://www.mysite.com/mypage.asp

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: neosarcastic
Date Posted: 11 February 2004 at 7:21am

Hi, thanks for writing back,

I am accessing the page like this :

http://www.mysite.com/mypage.asp - http://www.mysite.com/mypage.asp

I click a link on the index page that takes me to the login.asp. That is when I get the code.

Tony

Posted By: pmormr
Date Posted: 11 February 2004 at 3:23pm

make sure the link to your login.asp page is also in that format

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: neosarcastic
Date Posted: 12 February 2004 at 12:00pm

yes i have linked it that way in my html and also tried linking it relatively.

recently i have made a test page with only this code:

<html>
<body>
Today is: <% = Date %>
</body>
</html>

then i linked to this page instead of my new login.asp and it loads fine. this test.asp page is in the same dir with the same permissions as the login.asp. This tels me that it may be an error in my code:

<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_connPFT_STRING;
Recordset1.Source = "SELECT * FROM dbo.password";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Server.HTMLEncode(Request.QueryString);
var MM_valUsername=String(Request.Form("username"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="directoryselect.htm";
var MM_redirectLoginFailed="accessdenied.htm";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_connPFT_STRING;
MM_rsUser.Source = "SELECT username, password";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM dbo.password WHERE username='" + MM_valUsername.replace(/'/g, "''") + "' AND password='" + String(Request.Form("password")).replace(/'/g, "''") + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
    // username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername;
    if (MM_fldUserAuthorization != "") {
      Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value) ;
    } else {
      Session("MM_UserAuthorization") = "";
    }
    if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
      MM_redirectLoginSuccess = Request.QueryString("accessdenied");
    }
    MM_rsUser.Close();
    Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>

Posted By: pmormr
Date Posted: 12 February 2004 at 6:17pm

well i can tell that you definitely designed that with Dreamweaver UltraDev or equivalent... and i'm not even sure that's ASP code i don't think that the bracket "{}" is valid in asp

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: neosarcastic
Date Posted: 13 February 2004 at 10:10am

SOLVED!!!

I can sleep now, the table that i was storing passwords in (dbo.password) was not set to select (or read) by any users. this is why they could not use it.

It all came down to one checkmark in SQL.