Re: Using Access 2000 w/FP2003 w/XP Home Edition

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Spencer (kspencer_at_takempis.com)
Date: 09/27/04


Date: Mon, 27 Sep 2004 15:39:23 -0400

Hi Bob,

> Folks, I'm new to FP & the web world.
>
> I've tried using the Database Interface Wizard to build a
> database to integrate into a web page and get errors.

Well, you've got a lot of guts, I'll have to give you that! New to the web
AND wanting to create a web database app! Better buy some Grecian Formula
today!

A web site can be nothing more than folders and files on a virtual directory
on a web server. This is what is referred to as "static" content. It is just
what it is, like a bunch of Word documents in a web folder, except that,
instead of Word, these are HTML documents.

When you want your web pages to dynamically display data fetched from a
database, you're talking about a different kind of animal: A Web
Application. A Web Application is what it sounds like: A program or
application that dynamically creates HTML documents based upon processing
logic on the server.

A Web Application, unlike a web site of static HTML documents, requires
certain things in order to operate. The first thing it requires is a web
server. A web server handles incoming Requests for web documents and
resources. In addition, IIS (Internet Information Services) also can (and
does) host ISAPIs (Internet Server Application Programming Interfaces),
which are a kind of application that is hosted in the context of a web
server. The web server receives a Request for a .asp or .aspx file, and by
the extension, knows to hand off the Request to the ISAPI that is assigned
to handle such requests.

In other words, you cannot use a "disk-based" (which means not using a web
server) web for database connectivity. You MUST use a server-based web, and
on a web server that supports the ASP or ASP.Net ISAPI. That would be IIS,
in your case.

XP Home does not support IIS. XP Pro does.

> Also, if the upgrade is needed, recently I noticed
> several upgrades to XP Pro with the note (not full
> version). Any idea if these would work ?

These? I don't see what you're looking at, so I can't say. You found
something somewhere that says something about something. That's all I know.

Best of luck to you!

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living
"Bob Cultrona" <rcultrona@corvette-motorsports.com> wrote in message
news:23d001c4a4c7$abd70860$a501280a@phx.gbl...
> Folks, I'm new to FP & the web world.
>
> I've tried using the Database Interface Wizard to build a
> database to integrate into a web page and get errors.
>
> I created Access databases and cannot use them with
> FP2003 w/o getting various errors.
>
> I nosed around MS KBase and found a note that XP Home
> edition does not support IIS.
>
> Therefore, in order to create a "disk based" web site
> (during development), do I need to upgrade my PC from
> Home Edition to XP Professional Edition in order to use a
> database such as Access ?
>
> Also, if the upgrade is needed, recently I noticed
> several upgrades to XP Pro with the note (not full
> version). Any idea if these would work ?
>
> Thanks in  advance.........I'm semi-lost and very
> frustrated with this whole process so far !
>
> Bob
>
>


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)
  • 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)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)