Re: Database Connection/ Results not working

From: Thomas A. Rowe (tarowe_at_mvps.org)
Date: 08/24/04


Date: Tue, 24 Aug 2004 18:12:49 -0400

After you have created your database connection and renamed your page to .asp, you must publish the
site to a Windows IIS server to test your pages. You can not test any thing under Windows XP Home
that requires a MS Web server, as none are supported.

-- 
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"Carol" <anonymous@discussions.microsoft.com> wrote in message
news:560e01c48a26$649abf70$a301280a@phx.gbl...
> 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

  • Re: Create a database to store form results
    ... To preview an asp page you need to view it through a web server. ... If you are using an Access database, you must use a Windows server. ...
    (microsoft.public.frontpage.programming)
  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: help with 2000i on win2k server (sp3 on database)
    ... See Leonard's post for the config options. ... If the server is mangling itself, then ANYTHING running on the server ... that I work with will support the database AND the application. ... As for Windows vs. Linux/NetWare, I can agree, but I also see MANY ...
    (comp.databases.btrieve)
  • Re: nt4.5 to w2003
    ... keep in mind that there basically is two different things you can do to move from an NT 4 (SAM Database) domain to an Active Directory Domain. ... You can choose to upgrade the domain from NT 4 to Windows 200x Active Directory. ... The thing to keep in mind here is that you have to Upgrade an NT 4 PDC to Windows 200x. ... You could download and install Virtual Server 2005 if you needed to upgrade an NT 4 machine to Windows 200x and your real hardware either does not support NT 4, or the NT 4 hardware you have does not really support Windows 200x. ...
    (microsoft.public.windows.server.migration)
  • Re: Using Access 2000 w/FP2003 w/XP Home Edition
    ... > via my IE browser to add test data to a database, ... That's because ASP pages/code need to 'served" from a server to work. ... >> Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.programming)