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

anonymous_at_discussions.microsoft.com
Date: 09/28/04 

Date: Tue, 28 Sep 2004 09:13:25 -0700

Yeah Kevin........I'm wondering if I'm biting off more
than I should.

Thanks for the reply. Couple of questions.

Your reply cleared up what I was slowly coming to realize.

Yes, I want to do a "web application". I'm an old
mainframe programmer and "in the old days", we developed
a screen & program, added data to test databases and
tested the application via CICS.

I was under the impression FP could work the same way.

>From what you said, I do need to publish my screens and
databases to a "web server" that supports ASP, IIS and
the ISAPI's you mentioned.

Does this mean (publish) I need to move it to the company
that will host it someday ? FTP it to their server ?

Is there a way to create and test web applications on my
PC BEFORE FTP'n it anywhere ?

Or is the normal development process is to create the
HTML pages and databases on your PC, then FTP it to a
server ?

Would a good option be to purchase a small server or can
I do what I want via upgrading to XP Pro ?

Thanks a million for the reply. I don't have any web
folks to bounce ideas off and sometimes just reading all
the terminology makes my head spin. I try to relate it to
Cobol, CICS & DB2........

Bob
>-----Original Message-----
>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

  • Re: Unable to get global configuration data.
    ... It did say All Unassigned with a port. ... I reset IIS. ... on the web server. ... Unable to connect to database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Upgrade from MSDE to SQL
    ... Hard to say whether the database is of any use to you now you are partway ... upgrade just in case. ... But FIRST I would in any case see if adding SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • beginners question impersonation
    ... Microsoft Access database is on the c: drive on the IIS ... server) and have therefore copied the database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • 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: Using Access 2000 w/FP2003 w/XP Home Edition
    ... your web site on the server. ... >>> database to integrate into a web page and get errors. ... > Programming Interfaces), ... do I need to upgrade my PC from ...
    (microsoft.public.frontpage.programming)