Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Frontpage 2003 Database Interface Wizard problem

Posted on 2003-11-18
19
Medium Priority
?
5,712 Views
Last Modified: 2013-12-24
1. I was unable to get the wizard to use an existing Access database. That option remains greyed out.  What needs to be in place to be able to select this option?

2. I selected the option to create a new Access database, and the wizard completed, but when I attemp to open the results_page.asp, I get the Http 500 internal server error.  I think I have the Internet guest account write permissions to the MDB.  Any ideas?
0
Comment
Question by:Thirt
[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
  • 9
  • 5
  • 5
19 Comments
 
LVL 31

Expert Comment

by:seanpowell
ID: 9779032
There are several possible reasons for this:.

You're using a Web site based on Microsoft Windows SharePoint Services
Web sites located on servers running on Windows SharePoint Services use a different set of features to display data. To display data on a Web site based on Windows SharePoint Services, click the Data menu, and then click Insert Data View.

You're using a disk-based Web site
When you open the site in Microsoft FrontPage, check to see that the location specified at the top of the Folder List begins with http://. An example of a valid location is http://www.example.com/subsite1.
If the location appears to be a path to a local or network location— such as C:\Documents and Settings\User\My Documents\My Web Sites\Subsite1— you'll need to create a Web site at a location that uses the HTTP protocol. A Web site on a local or network drive is not a valid location to display database-enabled pages.

Your authoring settings do not allow Active Server Pages (ASP)
On the Tools menu, click Page Options.
Click the Authoring tab.
In the FrontPage and SharePoint Technologies area, select the Active Server Pages check box.

Your authoring settings do not allow Author-time Web Components
On the Tools menu, click Page Options.
Click the Authoring tab.
Select the Author-time Web Components check box.

You're not working in a Web site
Check to make sure that you opened a server-based Web site and not just a new page outside of a Web site.

Your Web site might be hosted on an incorrectly configured Web server. To use ASP, the following technologies are required on your Web server:

Microsoft Windows 2000, Windows Server 2003, or Windows XP Professional
FrontPage 2000 Server Extensions or later or SharePoint Team Services v1.0
IIS 5.0 or later

To use ASP.NET, the following technologies are required on your Web server:
Windows 2000, Windows Server 2003, or Windows XP Professional
ASP.NET
FrontPage 2000 Server Extensions or later or SharePoint Team Services v1.0
IIS 6.0 or later

Just need to check these things before looking at anything else :-)
0
 

Expert Comment

by:levinho
ID: 9781208
Is your server your site is hosted on Linux or Win based.  I don't think that Access databases can use the wizard of not on a Win-based site.

Check Tools-->Web Settings -->Database.

It should tell you if database use is supported.

HL
0
 
LVL 4

Author Comment

by:Thirt
ID: 9782264
Thanks for the details, I will check those out when I get back home.

But here's what I know. I'm running Windows 2003 Server and IIS6.  I have installed Sharepoint to play around with it, but I'm not using it an want to remove it. I'm attemping to get started with ASP classic and will starting playing with ASP.net later.

0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Expert Comment

by:levinho
ID: 9782308
Try to see if this works:

<%@ Language=VBScript %>
<%

Dim objField
Dim strValue

set cn = server.CreateObject("ADODB.Connection")
set objRS = server.CreateObject("ADODB.Recordset")
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("YOURDATABASENAME.mdb")& ";"
cn.Open

sql = "SELECT * FROM X"  (you need to change X to the name of the table in YOURDATABASENAME)

objRS.Open sql, cn

For Each objField in objRS.Fields
              strValue = objField.Value
                Response.Write (strValue)
Next

objRS.Close
cn.Close

%>


Howard
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 9782348
Let us know after you're removed it - running databases on a SharePoint server is different than from what you've been used to  doing...
0
 
LVL 4

Author Comment

by:Thirt
ID: 9803453
Looks like I installed Share point 2002 beta.  I used the add/remove programs to remove it.  anything else needed to remove this?

When I go to IIS manager and look at the tasks options for my web site, they are:
-convert server extenstions 2002 web to directory
-recalucalate server extentions 2002 web
-delete server extentions 2002 web

Howard, I added a blank page to the same folder that holds the Access database the Front page interface wizard created, changed the databasename and table and get the following error:

The page cannot be displayed
You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.
--------------------------------------------------------------------------------

Please try the following:

Contact the Web site administrator if you believe this directory should allow execute access.
HTTP Error 403.1 - Forbidden: Execute access is denied.
Internet Information Services (IIS)

0
 
LVL 4

Author Comment

by:Thirt
ID: 9803480
One more bit of information if this helps.  When I click on Data/Insert Data view I get the following error:

http://www.goferboy.com/images/asperror.bmp

0
 

Expert Comment

by:levinho
ID: 9803702
Can you put in here the actual code you used?

Howard
0
 
LVL 4

Author Comment

by:Thirt
ID: 9804168
<%@ Language=VBScript %>
<%

Dim objField
Dim strValue

set cn = server.CreateObject("ADODB.Connection")
set objRS = server.CreateObject("ADODB.Recordset")
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("class83.mdb")& ";"
cn.Open

sql = "SELECT * FROM results"  

objRS.Open sql, cn

For Each objField in objRS.Fields
             strValue = objField.Value
                Response.Write (strValue)
Next

objRS.Close
cn.Close

%>
0
 
LVL 4

Author Comment

by:Thirt
ID: 9804189
Hold on....I check the sub folder that FP created for the database, and the location were I put this test code (/FPDB) and checked the properties in IIS manager and it didn't even have Read rights.  So I changed it to Read and gave permissions to scripts to run and your code now works and returns the recordset!!

But the Result_page.asp code is still failing and I get the error: HTTP 500 - Internal server error
0
 

Accepted Solution

by:
levinho earned 1000 total points
ID: 9804216
You need to turn off the "friendly" error messages to see the true error.

If you are using IE, go to tools--> internet options --> advanced --> look for and uncheck Friendly HTTP errors (or something like that)

Re-run the page and tell us the error.

Also,  put the code for the results_page.asp here is you could.

Howard
0
 
LVL 4

Author Comment

by:Thirt
ID: 9804242
ok, here's the error details.

Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/NW/Class83list/results_page.asp, line 60

The Include file '../_fpclass/fpdblib.inc' cannot contain '..' to indicate the parent directory.


Should I still put in the code for the results_page.asp?
0
 

Expert Comment

by:levinho
ID: 9804301
Could you or at least around and including line 60?

0
 
LVL 4

Author Comment

by:Thirt
ID: 9804306
OK, line 60 goes on forever....but here it is....



<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- View</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.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"> Results Page </font></b>
      </td>
    <td width="50%" align=right>
      <table>
        <tr>
          <td>
            Results Page
| <a href="submission_form.asp" target="_top">Submission Form</a>
| <a href="editor/database_editor.asp" target="_top">Database Editor</a>
          </td>
        </tr>
      </table>
      </td>
  </tr>
</table>


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

<table width="100%" border="1">
  <thead>
    <tr>
          <th align="left"><b>Key</b></th>
          <th align="left"><b>Name</b></th>
          <th align="left"><b>MaidenName</b></th>
          <th align="left"><b>Address</b></th>
          <th align="left"><b>City</b></th>
          <th align="left"><b>State</b></th>
          <th align="left"><b>Zip</b></th>
          <th align="left"><b>Phone</b></th>
          <th align="left"><b>Email</b></th>

   </tr>
  </thead>

  <tbody>

  <!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,MaidenName,Address,City,State,Zip,Phone,Email" s-columntypes="3,202,202,203,202,202,202,202,202" s-dataconnection="class83" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="Key,Name,MaidenName,Address,City,State,Zip,Phone,Email" s-criteria s-order s-sql="SELECT * FROM Results" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" startspan preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" --><!--#include file="../_fpclass/fpdblib.inc"-->
0
 
LVL 31

Assisted Solution

by:seanpowell
seanpowell earned 1000 total points
ID: 9804514
Open IIS

1. In your Web site, right-click the folder or virtual folder containing your web site.
2. Choose Properties from the pop-up menu, and then click the Home Directory or Virtual Directory tab.
3. Click Configuration, and then click the Options tab.
4. Select Enable Parent Paths, and then click OK.
0
 
LVL 4

Author Comment

by:Thirt
ID: 9804546
It works!!! Great help guys.  Let me increase the points and split it up since turning off friendly HTTP errors put us on the right track
0
 
LVL 4

Author Comment

by:Thirt
ID: 9804554
opps, I meant to give George the accepted.  Thanks again!!!
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 9804555
Glad you're back on track! Thanks.
0
 
LVL 31

Expert Comment

by:seanpowell
ID: 9804557
Don't worry about it :-)
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

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…
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
Suggested Courses

636 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