Solved

Getting code error when trying to run .asp page from FrontPage 2002

Posted on 2004-03-22
11
352 Views
Last Modified: 2013-12-24
I am trying to link a access database from Frontpage 2002. I went through the database wizard in Frontpage and it created 2 pages. One was called submission_form.asp and the other is results_page.asp. I created the database to contain three fields. Customer, Unit and History. When run the results_page.asp it comes up with no records. The database started with no records so I went into access and added one to test it. When I ran the results_page.asp after putting the data in the database it still didn't show any records. When I hit Preview in Browser on the submission_form.asp it gave me the following code instead of a page with the fields on it:
<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
      Err.Clear

      Set fp_conn =  Server.CreateObject("ADODB.Connection")
      FP_DumpError strErrorUrl, "Cannot create connection"

      Set fp_rs = Server.CreateObject("ADODB.Recordset")
      FP_DumpError strErrorUrl, "Cannot create record set"

      fp_conn.Open Application("production_ConnectionString")
      FP_DumpError strErrorUrl, "Cannot open database"

      fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
      FP_DumpError strErrorUrl, "Cannot open record set"

      fp_rs.AddNew
      FP_DumpError strErrorUrl, "Cannot add new record set to the database"
      Dim arFormFields0(3)
      Dim arFormDBFields0(3)
      Dim arFormValues0(3)

      arFormFields0(0) = "Company"
      arFormDBFields0(0) = "Company"
      arFormValues0(0) = Request("Company")
      arFormFields0(1) = "Unit"
      arFormDBFields0(1) = "Unit"
      arFormValues0(1) = Request("Unit")
      arFormFields0(2) = "History"
      arFormDBFields0(2) = "History"
      arFormValues0(2) = Request("History")

      FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0


      fp_rs.Update
      FP_DumpError strErrorUrl, "Cannot update the database"

      fp_rs.Close
      fp_conn.Close

      FP_FormConfirmationFromArrays "text/html; charset=windows-1252",_
                                    "Form Confirmation",_
                                    "Thank you for submitting the following information:",_
                                    "submission_form.asp",_
                                    "Return to the form.",_
                                    arFormDBFields0,_
                                    arFormValues0

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<% Response.Buffer = True %>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- New</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">

<table width="100%" align=left>
  <tr>
    <td width="50%">
        <b><font size=+3 color="#000080"> Submission Form </font></b>
      </td>
    <td width="50%" align=right>
      <table>
        <tr>
          <td>
            <a href="results_page.asp" target="_top">Results Page</a> |
Submission Form

          </td>
        </tr>
      </table>
      </td>
  </tr>
</table>


<p>
<br clear="all">
<hr>
<p>

<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form1_Validator(theForm)
{

  if (theForm.Company.value.length > 255)
  {
    alert("Please enter at most 255 characters in the \"Company\" field.");
    theForm.Company.focus();
    return (false);
  }

  if (theForm.Unit.value.length > 5)
  {
    alert("Please enter at most 5 characters in the \"Unit\" field.");
    theForm.Unit.focus();
    return (false);
  }

  var checkOK = "0123456789-";
  var checkStr = theForm.Unit.value;
  var allValid = true;
  var validGroups = true;
  var decPoints = 0;
  var allNum = "";
  for (i = 0;  i < checkStr.length;  i++)
  {
    ch = checkStr.charAt(i);
    for (j = 0;  j < checkOK.length;  j++)
      if (ch == checkOK.charAt(j))
        break;
    if (j == checkOK.length)
    {
      allValid = false;
      break;
    }
    allNum += ch;
  }
  if (!allValid)
  {
    alert("Please enter only digit characters in the \"Unit\" field.");
    theForm.Unit.focus();
    return (false);
  }

  if (theForm.History.value.length > 255)
  {
    alert("Please enter at most 255 characters in the \"History\" field.");
    theForm.History.focus();
    return (false);
  }
  return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><form METHOD="POST" action="submission_form.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1" webbot-action="--WEBBOT-SELF--">

<!--webbot bot="SaveDatabase" suggestedext="asp" s-dataconnection="production" s-recordsource="Results" s-form-fields="Company Unit History" s-form-dbfields="Company Unit History " b-usedbfieldsforconfirmation="True" u-asp-include-url="../../_fpclass/fpdbform.inc" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="43152" -->

<p><b>Company</b><br>
&nbsp;<!--webbot bot="Validation" s-display-name="Company" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="Company" size="64" value="" maxlength="255"><br>
</p>
<p><b>Unit</b><br>
&nbsp;<!--webbot bot="Validation" s-display-name="Unit" s-data-type="Integer" b-value-required="False" i-maximum-length="5" --><textarea rows="10" name="Unit" cols="5"></textarea><br>
</p>
<p><b>History</b><br>
&nbsp;<!--webbot bot="Validation" s-display-name="History" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="History" size="64" value="" maxlength="255"><br>
</p>


<p><input type="submit" value="    OK    "><input type="reset" value=" Reset "></p>

</form>

</body>

</html>



Can anyone help me with this and tell me what I could be doing wrong. I am running XP pro and ran it from myweb in My Documents. I also tried moving it to a server we have setup on the network. I put it to \\server\inetpub\wwwroot\production. The server is running Windows 2000 Server and I set up and ODBC account linking to the database in the production folder. I really need some help getting this running. If anyone knows an easier way to do this I will be open to suggestions. Ive read the asp wizard stuff on Microsoft.com and numberous files on asp and they all go through the same steps that end up with the same results.
Thanks,
Josh Enochs
0
Comment
Question by:enochstek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 31

Expert Comment

by:seanpowell
ID: 10656434
>>I am running XP pro and ran it from myweb in My Documents.
When you're using ASP, you need to run it through IIS - which needs to be installed on your PC. (Let me know if it isn't)

So - the site needs to be either in C:/inetpub/wwwroot/submission_form.asp. or in a subweb C:/inetpub/wwwroot/myweb/submission_form.asp

Then, you open the site in the browser using this:

http://localhost/submission_form.asp - or in the second case, http://localhost/myweb/submission_form.asp

You can't run the asp pages using C://My Documents/myweb, because the code needs to use the asp engine in IIS.

Let me know...

Thanks,
Sean
0
 

Author Comment

by:enochstek
ID: 10657464
I also tried running it off the server which has IIS installed and it did the same thing.
Josh Enochs
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 10657530
>>The server is running Windows 2000 Server and I set up and ODBC account linking to the database in the production folder.

The code above states:
fp_conn.Open Application("production_ConnectionString")

which FrontPage normally defines in the global.asa file in the root of the site. If you have created a new connection to the db, then you need to make sure your code recognizes it.

When you open the live site on the server, and go to Tools > Web Settings > Database, what happens when you verify the connection?
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

Author Comment

by:enochstek
ID: 10658570
Ok, When I open frontpage on my XP Pro machine and then go to File - Open and point it to the Web5 that is on the Server in inetpub\wwwroot\production and verify the connection it verifies it and puts a green checkmark next to it.
0
 

Author Comment

by:enochstek
ID: 10663312
Ok Seanpowell,
I got home and put the Myweb (which contained the forms and my database) folder into \inetpub\wwwroot and changed my database path to use that database and I verified it. It checked ok and was verified. I then went to http:\\localhost\index.htm and it brought up my index page. i then clicked on the submissions form link and it brought up the submission form and not asp code which is right but then when I typed in data in the three fields and hit submit it said thank you for submitting like it had worked, but then when I go to the database, the data that I entered isn't there?!?!? Any idea why it didn't update it?
Thanks,
Josh Enochs
0
 
LVL 31

Accepted Solution

by:
seanpowell earned 500 total points
ID: 10676999
Sorry Josh, had an emergency yesterday...
This may be a permission issue - or just a naming one.

Can you have a look through this?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;219158



0
 

Author Comment

by:enochstek
ID: 10678194
Sean,
I looked at the link you sent me and I have been through that a few times already. I think I have got a problem with asp or something. When I publish my webpage to the server it says that asp is not supported on the server I am publishing to so the three pages will not work properly. But I am running Server 2000 with IIS 5.0. Do you know what would cause this?
0
 

Author Comment

by:enochstek
ID: 10682520
Sean,
I got it to update the database now. It was because the frontpage extensions were #@!#@ up. I reinstalled it on the server and it worked. Now I am getting another problem though. When I go to the Form Properties on my Submission.asp page to change what field the text box is linked to I click on Options to go in and change it and where it says what database connection to use it has my database name and it says connecting to database and then gives me this error:

Server error: Unable to retrieve the list of record sources from a database using the connection string:

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/production.mdb.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------


Source: ADO
Number: -2146824584 (0x800a0e78)
Do you know what this is?
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 10682574
Were you using a username and passowrd for the db?
0
 

Author Comment

by:enochstek
ID: 10682614
Nevermind! I feel so stupid! It was because I was in the database on another pc. Thanks for your help!
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 10682693
Hey - you wouldn't believe some of the things I've done. I can't even mention them here...

I'm so happy you're back on track :-)
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question