Solved

Frontpage 2003 Database Interface Wizard problem

Posted on 2003-11-18
19
5,674 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
  • 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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 250 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 250 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now