• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5729
  • Last Modified:

Frontpage 2003 Database Interface Wizard problem

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
Thirt
Asked:
Thirt
  • 9
  • 5
  • 5
2 Solutions
 
seanpowellCommented:
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
 
levinhoCommented:
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
 
ThirtAuthor Commented:
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
levinhoCommented:
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
 
seanpowellCommented:
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
 
ThirtAuthor Commented:
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
 
ThirtAuthor Commented:
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
 
levinhoCommented:
Can you put in here the actual code you used?

Howard
0
 
ThirtAuthor Commented:
<%@ 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
 
ThirtAuthor Commented:
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
 
levinhoCommented:
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
 
ThirtAuthor Commented:
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
 
levinhoCommented:
Could you or at least around and including line 60?

0
 
ThirtAuthor Commented:
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
 
seanpowellCommented:
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
 
ThirtAuthor Commented:
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
 
ThirtAuthor Commented:
opps, I meant to give George the accepted.  Thanks again!!!
0
 
seanpowellCommented:
Glad you're back on track! Thanks.
0
 
seanpowellCommented:
Don't worry about it :-)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 9
  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now