Re: Cant test database access on home machine
- From: "Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 08 Jul 2005 22:26:25 GMT
Ron
This all worked wonderfully. I ended up uninstalling and then reinstalling
IIS and its Frontpage Extensions and then followed your advice and bingo -
it all worked.
I am very grateful. Thanks.
Cheers...Alan
"Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42ce702a$1@xxxxxxxxxxxxxxxxxxxxxxxx
> Thanks Ron. I will give this a go and let you know.
>
> Cheers...Alan
>
>
> "Ronx" <ronx917@xxxxxxxxxxx> wrote in message
> news:e7bh8Q7gFHA.1612@xxxxxxxxxxxxxxxxxxxxxxx
>> If you are opening your web in FrontPage using a file system address,
>> such as C:\path\to\web\webname, then you are using a disc-based web,
>> which must be published to a server running FrontPage extensions.
>>
>> In WinXP PRO, install Internet Information Service (IIS) and the
>> FrontPage extensions. This will create a website in C:\inetpub\wwwroot.
>> Open the Extensions MMC (Control Panel->Administration Tools->Internet
>> Information Services Manager
>> Right click on the Default Web, then All Tasks and Check Server
>> Extensions.
>>
>> Open the disc-based web in FP, then publish to a subweb, say
>> http://localhost/subwebname
>>
>> If the disc-based web is already in C:\inetpub\wwwroot, then publish it
>> to some other location on your hard disc. Delete the web contents, then
>> check the extensions as above. Finally, publish the disc-based web to
>> the server as above.
>>
>> In future, always open your web as http://localhost/subwebname
>> --
>> Ron Symonds
>> Microsoft MVP (FrontPage)
>> Reply only to group - emails will be deleted unread.
>>
>> "Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:42ce5408@xxxxxxxxxxxxxxxxxxxxxxxx
>>> Ron
>>>
>>> Thanks for this - but I am not sure what it means for me. I am running
>>> everything off the c: drive. Is there a way I can turn on or test
>>> whether the Server Extensions are running? They were installed as part
>>> of the XP Pro installation.
>>>
>>> Cheers...Alan
>>>
>>> "Ronx" <ronx917@xxxxxxxxxxx> wrote in message
>>> news:OLjroF6gFHA.720@xxxxxxxxxxxxxxxxxxxxxxx
>>>> For the discussion web:
>>>>
>>>> The text comes from _derived/nortbots.htm. "nortbots" stands for No
>>>> RunTime webBots, which implies there are no Server Extensions.
>>>>
>>>> nortbots.htm only appears in four cases:
>>>> 1) You are testing on a disc-based website, which includes a FP
>>>> disc-based site that is being browsed through a web-server.
>>>> 2) You are testing on a website that does not have server extensions
>>>> installed or running
>>>> 3) The site (or form page) was FTPed from a disc-based web, or
>>>> published using a FTP address for the destination. Publish must be to
>>>> a URL of the form http://example.com
>>>> 4) There is a bug associated with FrontPage98 which causes this
>>>> problem.
>>>>
>>>> --
>>>> Ron Symonds
>>>> Microsoft MVP (FrontPage)
>>>> Reply only to group - emails will be deleted unread.
>>>>
>>>> "Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>> news:42ce480b$1@xxxxxxxxxxxxxxxxxxxxxxxx
>>>>> Dear enthusiast
>>>>>
>>>>> I am having trouble editing, adding and deleting database records, but
>>>>> not viewing records, using Frontpage. I am using:
>>>>> FP 2003 SP1
>>>>> Windows XP Proferssional with IIS and Microsoft Server Extensions
>>>>> added from
>>>>> the supplied CD
>>>>> This is all run on the one computer.
>>>>>
>>>>> I am using the Database Interface Wizard to create the database and
>>>>> web
>>>>> pages.
>>>>> I have checked the permissions on the database
>>>>> (Tools>Options>Tables/Queries
>>>>> and confirmed Rum Permissions is set to Users (and not Owners)
>>>>> I call up the web page in Internet Explorer using: http://localhost/
>>>>> All the pages load properly, the internal hyperlinks and frames work
>>>>> properly, I could display existing records, but I can only view
>>>>> records, not
>>>>> edit, delete or add new records. For example when trying to delete a
>>>>> record
>>>>> I get the following:
>>>>>
>>>>> Database Results Wizard Error
>>>>> Description: Could not delete from specified tables.
>>>>> Number: -2147467259 (0x80004005)
>>>>> Source: Microsoft JET Database Engine
>>>>>
>>>>> When I used the Discussion Web Site Wizard instead, again the pages
>>>>> loaded
>>>>> properly but I could not submit a discussion thread. I received the
>>>>> following message - but as far as I can see I have the FP Server
>>>>> Extensions
>>>>> installed.
>>>>>
>>>>> FrontPage Run-Time Component Page
>>>>> You have submitted a form or followed a link to a page that requires a
>>>>> web
>>>>> server and the FrontPage Server Extensions to function properly.
>>>>>
>>>>> This form or other FrontPage component will work correctly if you
>>>>> publish
>>>>> this web to a web server that has the FrontPage Server Extensions
>>>>> installed.
>>>>>
>>>>> Click the <Back> arrow to return to the previous page.
>>>>> Any suggestions???
>>>>>
>>>>> Cheers...Alan
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
"Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42c7464b@xxxxxxxxxxxxxxxxxxxxxxxx
> Thanks Kathleen
>
> I ran a Detect and Repair from Frontpage 2003 and then a Windows Update
> and an Office Update, just to be sure. There was one Windows software
> update but it did not mention Frontpage or SP1 and I don't know what it
> was for.
>
> In any event this fixed a number of the problems, but not all. I will now
> try things out using my Access database and the Database Wizard and go
> from there.
>
> Thank you very much for your kind assistance. I greatly appreciate your
> help.
>
> Kind regards...Alan
>
>
>
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@xxxxxxxx> wrote in
> message news:Okm4sf2fFHA.3692@xxxxxxxxxxxxxxxxxxxxxxx
>> Have you applied SP-1 to FrontPage 2003?
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>>
>> "Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:42c7321a$1@xxxxxxxxxxxxxxxxxxxxxxxx
>>> Kathleen
>>>
>>> This certainly improved things as the pages created by the Database
>>> Interface Wizard appear but are clearly not working properly. Please
>>> note that at this stage I am only using the pages and Database1 inserted
>>> by the FP Database Interface Wizard. It should be a pretty stock
>>> standard interface.
>>> 1. I can submit the Submission form and I do receive a Form Confirmation
>>> page but the submitted information is not incorporated into Database1
>>> (as indicated by opening the database and looking at the content of the
>>> table).
>>> 2. The results page does not show any results, including results
>>> manually added to the database table through MS Access.
>>> 3. I cannot get the Database Editor - Results page to show anything
>>> other than that shown below.
>>>
>>> Key Name Choice
>>> Database Results Wizard Error
>>> The operation failed. If this continues, please contact your server
>>> administrator.
>>>
>>>
>>>
>>> To check this out I edited the fpdbrgn1.inc file as you indicated in an
>>> earlier post but this did not have any effect so I changed it back
>>> again. The earlier post said:
>>>
>>> changed the line in The FP2003 code has changed slightly. To see the
>>> true error, open the hidden
>>> folder /_fpclass/ and edit the fpdbrgn1.inc file
>>>
>>> At about line 19, change :
>>>
>>> fp_DEBUG = False
>>> to :
>>> fp_DEBUG = True
>>>
>>> Any help would be appreciated.
>>>
>>> Cheers...Alan
>>>
>>>
>>>
>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@xxxxxxxx> wrote in
>>> message news:u4gJgu1fFHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
>>>> You need to preview via http - substitute http://localhost for
>>>> c:/Inetpub/wwwroot
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>>
>>>> "Alan" <alanlaird@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>> news:42c71cb3$1@xxxxxxxxxxxxxxxxxxxxxxxx
>>>>> Dear enthusiast
>>>>>
>>>>> I am having difficulty testing a web MSAccess database interface.
>>>>>
>>>>> Can I do this using the one computer?
>>>>>
>>>>> I am running Windows XP and have installed IIS and FrontPage Server
>>>>> Extensions which I am assuming act as a server.
>>>>>
>>>>> I create a web site using the Database Interface Wizard in
>>>>> c:/Inetpub/wwwroot
>>>>> When I open the web pages in Internet Explorer I get the message in
>>>>> yellow (below).
>>>>>
>>>>> Yet as far as I can determine I am using a server that supports Active
>>>>> Server Pages (ie IIS and FP Server Extensions).
>>>>>
>>>>> Any help would be appreciated as I have spent a day and a half trying
>>>>> to test a web linked database on my home machine before arranging for
>>>>> it to be hosted by a hosting service that hosts FrontPage extensions.
>>>>>
>>>>> Cheers...Alan
>>>>>
>>>>> The Database Results component on this page is unable to display
>>>>> database content. The page must have a filename ending in '.asp', and
>>>>> the web must be hosted on a server that supports Active Server Pages.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
.
- References:
- Cant test database access on home machine
- From: Alan
- Re: Cant test database access on home machine
- From: Kathleen Anderson [MVP - FrontPage]
- Re: Cant test database access on home machine
- From: Alan
- Re: Cant test database access on home machine
- From: Kathleen Anderson [MVP - FrontPage]
- Re: Cant test database access on home machine
- From: Alan
- Cant test database access on home machine
- Prev by Date: Re: HOW TO ID A FORM
- Next by Date: Re: XML Style Sheet Designer
- Previous by thread: Re: Cant test database access on home machine
- Next by thread: Re: Cant test database access on home machine
- Index(es):
Relevant Pages
|
