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

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

Date: Tue, 28 Sep 2004 12:49:22 -0400

Hi Bob,

Hang in there. I never worked on mainframes, but I started programming with
C on the DOS platform. It's just a matter of catching/keeping up! Bits are
bits, no matter how you slice 'em. Right?

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

FrontPage has the capability of publishing web sites. It's a little more
complicated than simply moving files from one machine to another. It is best
to use FrontPage to do your publishing for you. It does create a "copy" of
your web site on the server. Don't use FTP.

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

Second time you've used the word "FTP." Best to not think about FTP. Again,
let FrontPage handle that for you. Yes, there is. Just use a machine that
has IIS installed. Windows XP Pro does.

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

"FTP" again! Erase that acronym from your memory before it's too late! ;-)

You can develop locally and then publish, or work on your live site live. I
would advise the former rather than the latter. But it's a matter of your
choice.

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

XP Pro will do like a champ! 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living
<anonymous@discussions.microsoft.com> wrote in message
news:001f01c4a576$154824b0$a401280a@phx.gbl...
> 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: 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)
  • 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
    ... FTP it to their server? ... >> database to integrate into a web page and get errors. ... In addition, IIS (Internet Information ... do I need to upgrade my PC from ...
    (microsoft.public.frontpage.programming)
  • 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)