problem opening asp page

hi Everybody,

I just made a simple web site using Frontpage 2003 with a simple MS Accesss
database.

IF I try to open the asp page in a browser by typing
http://localhost/mysite/db.asp it opens just fine

However if I try to opeb it by typing c:/mysite/db.asp I get the following
error 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.

Any solution to this ?

tia

Re: problem opening asp page

John wrote:
> hi Everybody,
>
> I just made a simple web site using Frontpage 2003 with a simple MS
> Accesss database.
>
> IF I try to open the asp page in a browser by typing
> http://localhost/mysite/db.asp it opens just fine
>
> However if I try to opeb it by typing c:/mysite/db.asp I get the
> following error 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.
>
Why are you trying to open it using "c:/mysite/db.asp"? Are you trying to
edit it?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: problem opening asp page

Bob Barrows [MVP] wrote:
> John wrote:
>> hi Everybody,
>>
>> I just made a simple web site using Frontpage 2003 with a simple MS
>> Accesss database.
>>
>> IF I try to open the asp page in a browser by typing
>> http://localhost/mysite/db.asp it opens just fine
>>
>> However if I try to opeb it by typing c:/mysite/db.asp I get the
>> following error 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.
>>
> Why are you trying to open it using "c:/mysite/db.asp"? Are you
> trying to edit it?

I am no ASP expert (by a long, long way !!), but surely ASP pages will only
work as ASP pages when one is connected to a server.

Opening as http://localhost/mysite/db.asp will open it using IIS which is
installed locally (I assume). But opening as "c:/mysite/db.asp" would try to
open the page as a web page (using Internet Explorer perhaps ??). There
would be no connection to a server - hence the message.

I have certainly found this if I open an ASP page locally. I do not have IIS
(I am using XP Home), so I will always get this message. So to edit it, I
explicitly open it with an editor -UltraEdit is my choice.
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/
----------------------------------------

Re: problem opening asp page

Trevor L. wrote:
> Bob Barrows [MVP] wrote:
>> John wrote:
>>> hi Everybody,
>>>
>>> I just made a simple web site using Frontpage 2003 with a simple MS
>>> Accesss database.
>>>
>>> IF I try to open the asp page in a browser by typing
>>> http://localhost/mysite/db.asp it opens just fine
>>>
>>> However if I try to opeb it by typing c:/mysite/db.asp I get the
>>> following error 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.
>> Why are you trying to open it using "c:/mysite/db.asp"? Are you
>> trying to edit it?
>
> I am no ASP expert (by a long, long way !!), but surely ASP pages
> will only work as ASP pages when one is connected to a server.

Why are you telling me this? :-)

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: problem opening asp page

Bob Barrows [MVP] wrote:

> Why are you telling me this? :-)

I am not.

I am attempting to expand on your reply to the OP with my experience
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/
----------------------------------------

Re: problem opening asp page

I've just started learning frontpage and I bought a tutorial DVD in which
the person that produced it made a simple access database and then used
Frontpage 2003 to import the database file and display the content in a
table on an asp page.

She was able to open the asp file using this syntax: c:/mysite/db.asp so I
tried to do the same and it didn't work for me.

So my question is if this is not how it's supposed to work how in the world
was she able to open it correctly without using
http://localhost/mysite/db.asp syntax




"Bob Barrows [MVP]" wrote in message
news:uUKIXLwJHHA.4112@TK2MSFTNGP04.phx.gbl...
> John wrote:
>> hi Everybody,
>>
>> I just made a simple web site using Frontpage 2003 with a simple MS
>> Accesss database.
>>
>> IF I try to open the asp page in a browser by typing
>> http://localhost/mysite/db.asp it opens just fine
>>
>> However if I try to opeb it by typing c:/mysite/db.asp I get the
>> following error 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.
>>
> Why are you trying to open it using "c:/mysite/db.asp"? Are you trying to
> edit it?
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

Re: problem opening asp page

John wrote:
> I've just started learning frontpage and I bought a tutorial DVD in
> which the person that produced it made a simple access database and
> then used Frontpage 2003 to import the database file and display the
> content in a table on an asp page.
>
> She was able to open the asp file using this syntax: c:/mysite/db.asp so I
> tried to do the same and it didn't work for me.
>
> So my question is if this is not how it's supposed to work how in
> the world was she able to open it correctly without using
> http://localhost/mysite/db.asp syntax

Bob Barrows is clearly the expert, but off the top of my head, I woudl say:

She couldn't :-))

That is, she couldn't open it correctly without using
http://localhost/mysite/db.asp syntax (or without opening it on a server
supporting ASP).

Here is my attempt to open guestbook.asp on my local drive (from Windows
Explorer)
Trevor L.'s Guestbook
Note: Update and Delete are admin only functions

Action Name Comments Timestamp
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.
.............

Now try it on http://trevorl.mvps.org/guestbook.asp - no problems
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/
----------------------------------------

Re: problem opening asp page

John wrote:
> I've just started learning frontpage and I bought a tutorial DVD in
> which the person that produced it made a simple access database and
> then used Frontpage 2003 to import the database file and display the
> content in a table on an asp page.
>
> She was able to open the asp file using this syntax: c:/mysite/db.asp so I
> tried to do the same and it didn't work for me.
>
> So my question is if this is not how it's supposed to work how in
> the world was she able to open it correctly without using
> http://localhost/mysite/db.asp syntax
>

I would suspect there was some "movie magic". In order for code in an ASP
page to be executed, it needs to be requested via a web server.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: problem opening asp page

OK, thanks. That's probably it. She probably didn't feel like getting into
IIS since the course is about Frontpage


"Bob Barrows [MVP]" wrote in message
news:ec3ZSy1JHHA.2140@TK2MSFTNGP03.phx.gbl...
> John wrote:
>> I've just started learning frontpage and I bought a tutorial DVD in
>> which the person that produced it made a simple access database and
>> then used Frontpage 2003 to import the database file and display the
>> content in a table on an asp page.
>>
>> She was able to open the asp file using this syntax: c:/mysite/db.asp so
>> I tried to do the same and it didn't work for me.
>>
>> So my question is if this is not how it's supposed to work how in
>> the world was she able to open it correctly without using
>> http://localhost/mysite/db.asp syntax
>>
>
> I would suspect there was some "movie magic". In order for code in an ASP
> page to be executed, it needs to be requested via a web server.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>