Testing server

leonardpogrady · January 30th, 2010, 02:10 AM

Hi Old Pedant and Imar,
Thank you both for trying to help. I have been flat out on this site all day, I started using this forum after I attempted to get my failing log in page working. The first post I attempted was long detailed with a lot of topics I thought might be causing me grief. When I tried to post the thread it failed. Frustrated I broke it up in small parts and ended up with 10 strings that were hard to understand. (Sorry Imar.)
I will take your advice Imar and update DW as it has not been done for some time. Old pedant I agree DW seems as old as me at 51 but it is the only web development platform I know so I will stick with it for now. I uploaded the site using my host providers web based FTP platform. I have changed files and folders around today as some of my rollover images and their links were failing.
When I finished this I noticed the only .asp document that wont work is, you guessed it the log in page online.asp I am shifting all .asp files to the same level as the default.asp because I thought I might have file sharing problems with the folders. In a nut shell the only link or .asp file I can not get working is online.asp Here is my live web address http://www.debtorstocash.com
In the middle of the page is a green rollover image Judicial Management System, click that a new page opens, click the rollover image 3rd from left (log in) the file is online.asp
Do you know what the default failure page means?

leonardpogrady · January 30th, 2010, 02:34 AM

Hi Old Pedant and Imar,
Thank you both for trying to help. I have been flat out on this site all day, I started using this forum after I attempted to get my failing log in page working. The first post I attempted was long detailed with a lot of topics I thought might be causing me grief. When I tried to post the thread it failed. Frustrated I broke it up in small parts and ended up with 10 strings that were hard to understand. (Sorry Imar.)
I will take your advice Imar and update DW as it has not been done for some time. Old pedant I agree DW seems as old as me at 51 but it is the only web development platform I know so I will stick with it for now. I uploaded the site using my host providers web based FTP platform. I have changed files and folders around today as some of my rollover images and their links were failing.
When I finished this I noticed the only .asp document that wont work is, you guessed it the log in page online.asp I am shifting all .asp files to the same level as the default.asp because I thought I might have file sharing problems with the folders. In a nut shell the only link or .asp file I can not get working is online.asp Here is my live web address http://www.debtorstocash.com
In the middle of the page is a green rollover image Judicial Management System, new page opens, click the rollover image log in the file is online.asp
Do you know what the default failure page means?

leonardpogrady · January 30th, 2010, 04:18 AM

Hi,
Still working on above Title. When I test this online.asp file in the local host directory it fails asking for log. (Yet it is the starting page for the log in?)When I run this file live in DW it first starts as code only in the Browser, if I refresh the browser I see the live page?

Whats going on?

Leonard P.O'Grady
Whitsundays
Australia

Imar · January 30th, 2010, 05:29 AM

Quote:

When I test this online.asp file in the local host directory it fails asking for log

You're still not providing a lot of information. What "log"? A login dialog from the browser asking for a user name and password? Or the login in the actual HTML page in the browser, which is part of your site?

Are you running your site using IIS, the Windows web server? If so, maybe the login dialog appears because the web server account is not allowed to read from your files. Depending on the version of Windows / IIS you're using, this account may be IUSR_MachineName, Network Service or something else. Check out these articles for more info:

http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=287
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=263

And please, try to provide more, relevant detail. "it fails asking for log" is not a good problem description. It's not clear what "it" is, and what it is asking for exactly and how that looks. In order to provide you with relevant answers to your questions, you have to be crystal clear as to what situation you have and what problems you run into, or this is not going to work well.... ;-)

Cheers,

Imar

Old Pedant · January 30th, 2010, 07:23 PM

Well, "online.asp" is getting a 500 error, which *is* an ASP problem of some kind.

But I can't begin to guess exactly what the problem might be.

I think you need to show your code for that page. Then we can show you where to put in some debug code and how to avoid the 500 error while debugging.

Briefly, though, you do something like this:

Code:

<%
...
' for lines that can't cause errors, just leave them in as normal:
Set conn = Server.CreateObject("ADODB.Connection")
 
' but then "protect" lines that might cause an error so you can find out if they are doing so:
On Error Resume Next
    conn.Open "...your connection string..." ' easy to cause error with bad connection string
On Error Resume Next
If Err.Number <> 0 Then
    Response.Write "Error opening connection: " & Err.Number & ", " & Err.Description
    Response.End ' then stop!  So you get the message instead of a 500 error
End If
... continue like this to next vulnerable spot ...

Now, exactly where you slip in stuff like that with DW-generated code is the challenge. DW code is often obscure and poorly organized, so it becomes almost an art form.

Good luck!

p.s.: And quit bragging about being so young. Grumble. <grin style="but true"/>

leonardpogrady · January 31st, 2010, 01:38 AM

Hi Old Pedant and Imar,

I have rebuilt my login page, DSN (collectoz), Server Behaviours (Log In User definition box)
The new set up looks like this-
DSN â ODBC Microsoft Access Setup
Data Source Name: collectoz
Description: collectoz
Database: C:\... \asp\database\users.mdb
System Database: None
DSN collectoz test: Connection was made successfully. Application Database panel shows editable + and the connection and the tables can be viewed. (A first)
Server behaviour panel shows an editable + and Log In User, is the connection name, if double clicked Log In User Dialog Box Settings as follows-
Get Input From Form: Log In Form is default but is faded?
User Name Field: User ID Password Field: Password Validate Using Connection: collectoz
Table: Clients Username Column: UsrName Password Column: Pasword (less the second s not allowed) If Log In Succeeds, Go To: ssl/Login.asp If Log In Fails Go To: ssl/accessesdenied
Restrict User Access: Username and Password by default.
The above server behaviours match my MS Access Database users.mdb, the table clients matches all the above columns.
The File online.asp (my log In Page) starting code follows, you can see the first include file statement it requests (collectoz.asp). I did not include all the code for online.asp file as I think what I have shown does all the login handling and starts the new page that should run if correct user/password is used. I will show the starting code for online.asp, all the code for collectoz.asp This is what happens when I run the site local in Dreamweaver. I select default.asp in DW and press F12, it runs in browser with URL C:\Sites\Test Web Work\asp\TMP1gq72x3i1i.htm I select rollover image JMS it runs URL C:\Sites\Test Web Work\asp\Marketing.asp I select rollover image log In link it runs but shows code only, URL C:\Sites\Test Web Work\asp\online.asp I click the refresh button and it now displays the page properly, I input User Name: Len OâGrady, Password: guest and they are valid for my log In. Click Log In and I get Internet Explorer Can Not Display Page URL res://ieframe.dll/dnserror.htm You are probable going to ask what Internet Information Services - ISS V5.1
Online.asp starting code as follows- The whole code for the collectoz.asp file that is called follows after after below code.

Code:

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/collectoz.asp" -->
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("UserID"))
If MM_valUsername <> "" Then
  MM_fldUserAuthorization=""
  MM_redirectLoginSuccess="ssl/login.asp"
  MM_redirectLoginFailed="ssl/accessdenied.asp"
  MM_flag="ADODB.Recordset"
  set MM_rsUser = Server.CreateObject(MM_flag)
  MM_rsUser.ActiveConnection = MM_collectoz_STRING
  MM_rsUser.Source = "SELECT UsrName, Pasword"
  If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
  MM_rsUser.Source = MM_rsUser.Source & " FROM Clients WHERE UsrName='" & Replace(MM_valUsername,"'","''") &"' AND Pasword='" & Replace(Request.Form("Password"),"'","''") & "'"
  MM_rsUser.CursorType = 0
  MM_rsUser.CursorLocation = 2
  MM_rsUser.LockType = 3
  MM_rsUser.Open
  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then 
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    If (MM_fldUserAuthorization <> "") Then
      Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
    Else
      Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
      MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%>
<%
Dim strUserID
strUserID = "x"
if(Request.Form("UserID") <> "") then strUserID = Request.Form("UserID")
Dim strPassword
strPassword = "1"
if(Request.Form("Password") <> "") then strPassword = Request.Form("Password")
%>
<%
If strUserID <> "x" Then
If Not dbconn.EOF Then
Session("svUser")=dbconn.Fields.Item("Username").Value
Session("svPass")=dbconn.Fields.Item("Password").Value
Response.Redirect "../ssl/login.htm" 
else
Response.Redirect "loginfailed.asp"
End If
End If
%>

All of the code for collectoz.asp file as follows-

Code:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO" 
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_collectoz_STRING
MM_collectoz_STRING = "dsn=collectoz;"
%>

I must be getting close? Any idea why I am getting- Internet Explorer Can Not Display Page URL res://ieframe.dll/dnserror.htm

Cheers

Leonard P. O'Grady
Whitsundays
Australia

leonardpogrady · January 31st, 2010, 02:33 AM

Hi,

I thought I would include all the code in this thread for the online.asp file seen that last large thread posted ok. Have reliesed I have to re-log In after each step, that threw me.

Allt the code for my log in page online.asp follows-

Code:

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/collectoz.asp" -->
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("UserID"))
If MM_valUsername <> "" Then
  MM_fldUserAuthorization=""
  MM_redirectLoginSuccess="ssl/login.asp"
  MM_redirectLoginFailed="ssl/accessdenied.asp"
  MM_flag="ADODB.Recordset"
  set MM_rsUser = Server.CreateObject(MM_flag)
  MM_rsUser.ActiveConnection = MM_collectoz_STRING
  MM_rsUser.Source = "SELECT UsrName, Pasword"
  If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
  MM_rsUser.Source = MM_rsUser.Source & " FROM Clients WHERE UsrName='" & Replace(MM_valUsername,"'","''") &"' AND Pasword='" & Replace(Request.Form("Password"),"'","''") & "'"
  MM_rsUser.CursorType = 0
  MM_rsUser.CursorLocation = 2
  MM_rsUser.LockType = 3
  MM_rsUser.Open
  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then 
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    If (MM_fldUserAuthorization <> "") Then
      Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
    Else
      Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
      MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%>
<%
Dim strUserID
strUserID = "x"
if(Request.Form("UserID") <> "") then strUserID = Request.Form("UserID")
Dim strPassword
strPassword = "1"
if(Request.Form("Password") <> "") then strPassword = Request.Form("Password")
%>
<%
If strUserID <> "x" Then
If Not dbconn.EOF Then
Session("svUser")=dbconn.Fields.Item("Username").Value
Session("svPass")=dbconn.Fields.Item("Password").Value
Response.Redirect "../ssl/login.htm" 
else
Response.Redirect "loginfailed.asp"
End If
End If
%>


<TITLE>Online Services</TITLE>
</head>
<body bgcolor="336699" leftmargin="30" topmargin="0" marginwidth="30" marginheight="0" text="#FFFFFF" link="#FFFFFF" vlink="#CCCCCC" alink="#FFFFFF">
<table bgcolor="#336699" border="0" cellpadding="0" cellspacing="0" width="689" height="8" align="center">
  <tr> 
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="146" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="141" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="16" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="135" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="17" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="101" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="17" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="77" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="64" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td colspan="9"><img src="images/slice01.png" width="714" height="120"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="106" border="0"></td>
  </tr>
  <tr> 
    <td colspan="5"><img name="slice02" src="http://www.collectoz.com/images/slice42.gif" width="455" height="1" border="0"></td>
    <td rowspan="5">&nbsp;</td>
    <td rowspan="2" colspan="3"><img name="slice04" src="http://www.collectoz.com/images/slice44.gif" width="158" height="2" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="3"><img src="images/Site%20trafic.png" width="714" height="25"></td>
    <td rowspan="4">&nbsp;</td>
    <td rowspan="3"><img name="slice07" src="../images/slice47.gif" width="16" height="13" border="0"></td>
    <td rowspan="4">&nbsp;</td>
    <td rowspan="3"><img name="slice09" src="../images/slice49.gif" width="17" height="13" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="2"><img name="slice10" src="../images/slice50.gif" width="17" height="12" border="0"></td>
    <td height="9">&nbsp;</td>
    <td rowspan="2"><img name="slice12" src="../images/slice52.gif" width="64" height="12" border="0"></td>
    <td height="9"><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="11" border="0"></td>
  </tr>
  <tr> 
    <td><img name="slice13" src="http://www.collectoz.com/images/slice53.gif" width="77" height="1" border="0"></td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>
  <tr> 
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" bgcolor="#336699">&nbsp;</td>
    <td rowspan="2" colspan="3" bgcolor="#336699">&nbsp;</td>
    <td><img src="http://www.collectoz.com/images/spacer.gif" width="1" height="2" border="0"></td>
  </tr>
  <td height="13">&nbsp;  
</table>
<table width="714" border="0" cellspacing="0" cellpadding="0" height="143" align="center">
  <tr> 
    <td height="121" valign="top"> 
      <p><font face="Arial, Helvetica, sans-serif"><b>Online Services</b></font></p>
      <p><font size="-1" face="Arial, Helvetica, sans-serif">This is your gateway
           into debtorstocash.com online services. To proceed past this
          point 
        please enter your Login Name and your Password that was issued to you.
           If you would like to register for debtorstocash.com online services
          
        please <a href="../ssl/getauth.asp">click here now</a>. </font></p>
      <form ACTION="<%=MM_LoginAction%>" name="loginform" method="POST">
        <table width="650" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td valign="top" width="214" align="center"> <img src="images/Computer%20Image%20login.png" width="158" height="164"> </td>
            <td width="436" align="center" valign="middle"> <table width="364" border="0">
                <tr> 
                  <td width="104"><font face="Arial, Helvetica, sans-serif" size="-1"> 
                    <b>Login Name:</b></font></td>
                  <td width="250"> <input type=text name=UserID size=32 maxlength=30> 
				  <% Session("MM_Username") = UserID %>
                  </td>
                </tr>
                <tr> 
                  <td width="104"><b><font face="Arial, Helvetica, sans-serif" size="-1">Password:</font></b></td>
                  <td width="250"> <input type=password name=Password size=32 maxlength=30> 
                  </td>
                </tr>
                <tr> 
                  <td width="104"></td>
                  <td width="250"> <input type="submit" name="send" value="    Login    "> 
                    <input type="reset" name="clear" value="    Clear    "> </td>
                </tr>
              </table></td>
          </tr>
        </table>
      </form>
      <p><font face="Arial, Helvetica, sans-serif" size="-1">If you have any
          questions  or problems please contact us via <a href="contactus.htm">e-mail</a> or
           by calling 0447 043 018 during business hours. If you have forgotten
          
        your Login Name/Password or think that they may have been compromised
           please <a href="contactus.htm">contact us </a>immediately.</font></p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
    </td>
  </tr>
</table>
<table width="715" border="0" cellpadding="0" cellspacing="0" align="center">
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif" size="-1">| <a href="../main.asp">Home</a> 
      | <a href="http://www.collectoz.com/content/aboutus.htm">About Us</a> | <a href="http://www.collectoz.com/products.asp">Products &amp; 
      Services</a> | <a href="http://www.collectoz.com/content/online.asp">Online Services</a> | <a href="http://www.collectoz.com/content/contactus.htm">Contact 
      Us</a> | <a href="http://www.collectoz.com/content/jobs.htm">Jobs</a> |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font>
      <p><font face="Arial, Helvetica, sans-serif" size="-1">Site 
      Designed by Leonard P.O'Grady<br>
    <font size="-2">&copy; Content Copyright 2002 Leonard P.O'Grady
    ABN 80 340 504 889. </font></font></td>
  </tr>
</table>
</body>
</html>

I hope this helps you work out the problem.

Cheers

Leonard P. O'Grady
Whitsundays
Australia

Imar · January 31st, 2010, 05:10 AM

Quote:

Any idea why I am getting- Internet Explorer Can Not Display Page URL

And what address do you see in the address bar of the browser? In other words, which page can't be displayed?

Imar

leonardpogrady · January 31st, 2010, 05:45 AM

Hi Imar,

This is what happens when I run the site localy in Dreamweaver Mx.

I select default.asp in DW and press F12, it runs in browser with URL C:\Sites\Test Web Work\asp\TMP1gq72x3i1i.htm

I select rollover image JMS it runs URL C:\Sites\Test Web Work\asp\Marketing.asp I select rollover image log In link it runs but shows code only, URL C:\Sites\Test Web Work\asp\online.asp

I click the refresh button and it now displays the page properly.

I input User Name: Len OâGrady, Password: guest and they are valid for my log In.

Your Answer-

Click Log In and I get Internet Explorer Can Not Display Page

URL res://ieframe.dll/dnserror.htm

You are probable going to ask what Internet Information Services - ISS V5.1

Hope this shines some light.

Cheers

Len O'Grady

Imar · January 31st, 2010, 05:57 AM

Quote:

You are probable going to ask what Internet Information Services - ISS V5.1

No ;-) But I am going to ask what page the browser cannot display. Do you see an address somewhere? E.g. maybe the code is redirecting somewhere?

Imar