Database Connection/ Results not working

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Carol (anonymous_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 15:04:57 -0700

Hello -

I am having difficulty connecting my Microsoft Access
database to my FrontPage website. I'm using FP2003 and
MS Access 2000. I'm also using Windows XP Home Edition.
In my FP website, I choose, File, Import, and then import
my database into the fpdb folder, I follow the, what I
believe to be, appropriate prompts to establish a
connection. I then create a new page within my site and
choose Insert Database Results. Again, I follow the
appropriate prompts. On my page, I then get a message
stating "This page contains a component that requires a
different file extension. You should rename this page
with a file extension of .asp." I then save the page
with a .asp extension and still receive the same
message. When I preview the page, the field names are
present, but there is no query data and the message
states, "Database results region will not preview unless
this page is fetched from a web server with a web
browser." Another message states, "The Database Results
component on this page must have a filename ending
in .asp and the web must be hosted on a server that
supports Active Server Pages." When I publish the site,
I get a message for this specific page that states, "The
page cannot be displayed. HTTP 500 Internal Server
Error. Internet Explorer. At this point, I don't know
what I am doing wrong and what to do to correct it. Do I
need to somehow upload my Access database to a server on
my web hosting provider? If so, do I need to know a
server name and password? And if so, how do I go about
doing this? Does the fact that I am using Windows XP
Home Edition have anything to do with this? I have been
registered with my web host now since May and have not
been able to get past this point, which is not very far.
I was told when signing on with my web host, that it is
able to support Access database connections; however,
this is becoming very discouraging for me. I have called
Tech Support several times and they have been very nice,
but I still don't have an answer to my questions and a
resolution. I really need to make this work somehow, so
if someone is able to please provide the answers that I
need, I would appreciate it. Also, please provide
specific "step-by-step" instructions on how to correct
this issue. Thank you for your help.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Horrible (8x) Client-Server Performance
    ... App Server- 8 logical xeon 2.8ghz cpu, ... Fibre Channel SAN housing the database ... the Application server connecting to the DB server via client-server ... We have eliminated network to be the constraint by connecting both ...
    (comp.databases.progress)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)