Database content not displayed

H

Huber57

To all:

I am running Windows XP Professional and I have installed IIS on my
computer. I am using FP2003 and Access 2003. I have written a page that
draws on a query in Access. It has an .asp file extension. When I go to
view it in the browser, it displays the following message:

"The Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web must be
hosted on a server that supports Active Server Pages."

Thoughts?
 
H

Huber57

Thomas,

No, right now I am viewing the page through
C:\Documents and Settings\dough\My Documents\Database
Project\Webpages\test.asp
 
H

Huber57

Thomas,

I tried running it from:

http://localhost/Database/test2.asp

But, it tells me "You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials you supplied.
HTTP 401.3 - Access denied by ACL on resource
Internet Information Services"

Does that tell you anything?

Thanks for your help!
 
T

Thomas A. Rowe

Ok, open your site in FP using File Menu | Open Site and enter http://localhost, then once open
double click to open the Database subweb/subsite, then import your database, create a connection
name and let FP move the database to the fpdb folder, then try testing your page using File Menu |
Preview in Browser.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
H

Huber57

Thomas,
I have imported the database through the File|Import menu. I even adjusted
the settings "web settings" when I right click on the database.

Still not authorized to view the page.
 
T

Thomas A. Rowe

Open IIS MMC, then default web, then the specific web site, the under the home directory, make sure
the application is set to the name of the subweb.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
H

Huber57

Thomas,

I had to give myself permission in the "database" virutal directory. Now i
have permission to view the page but now it shows the field names (Project
Name, Start Date, etc) in a table format but below it says:

"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."

I think we are getting there!
 
T

Thomas A. Rowe

IUSER_MachineName need to have permissions as well.

Also which version of the FP extensions are installed?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
T

Thomas A. Rowe

With the site open in FP, Web / site settings, version 4 - 2000, version 5 = 2002

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
T

Thomas A. Rowe

Ok, then go to Admin Tools | SIIS MMC | Right click on the default web | All Tasks | Check Server
Extensions 2002 | Look for Server Health Check function and check all boxes to allow FP to repair
the permissions, etc.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
H

Huber57

Thomas,

The only selection I have is "Permissions Wizard...".

I don't have a "Check Server Extensions 2002" Option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frontpage ASP error message 7
frontpage error message 7
frontpage ASP error message 2
front page asp error message 1
Local computer used as server supporting ASP 1
RUNNING Frontpage / Database on my local pc 4
Database Connection/ Results not working 1
frontpage 2002 and db wizard and win xp pro 3

Top