Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FrontPage Preview (03)

    I'm testing out an ASP tutorial and am having a challenge previewing the page. I believe it should be returning the data/fields from the MS Access database. I am returned a blank page and the header is not correct either.

    Would someone kindly see if they can repeat the issue?

    Thanks,
    John

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: FrontPage Preview (03)

    Is the source of the page blank (e.g., right-click and View Source), or just the visible display? If the source is there, perhaps you can see a problem where your output is being treated as a comment or something like that. As another test, deliberately introduce a typo into the name of your database. You should get an ADO error message. If you don't, your server might not be processing the ASP or your ADO components might be missing.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    I can view the source and have tweaked the code to deliberately introduce a typo of the name of the database. I did not receive an ADO error message. I know that the ADO components are not missing as I utilize ADO via Excel VBA and it works (extracting records from the MS Access DB).

    The tutorial provides all necessary files ie DB and ASP files for running through the tutorial. One does not have to recreate them.

    Any other suggestions?
    John

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FrontPage Preview (03)

    Hi John

    Spookily, I was playing with this the other day to see if I could put it on my website, what version of Access are you running locally?. I have XP on my home machine and it refused to work other things I had to tweak was my IIS...I gave up in the end
    Jerry

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    Jerry,

    I am running on XP Professional and utlize MS Access 2003.

    Don't give up... <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> . It's time for a break.

    Regards,
    John

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FrontPage Preview (03)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> Have a look at the read me file it seems to have been tested on everything but 2K3

    "It has been tested on PWS 4 on Win 98 and IIS 4 and 5+ on Windows 2000/XP/NT4/98"
    Jerry

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    Strange....I get the same results on a W2K server.

    John

  8. #8
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: FrontPage Preview (03)

    Maybe it is an XP security setting. Posted to a web host, the query page works. (The page to add new records fails, I suspect because the database is in Access 97 format whereas the generic ODBC driver may be expecting Access 2000 format.)

    Temporarily functional link: http://www.carbocoma.com/db_tut/

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    It would appear that this particular tutorial is giving me a headache. I have decided to try Microsoft's FrontPage tutorial but I now have a new set of challenges.

    I"m working off a laptop and have IIS installed. I have created the default.asp and try to view it in a browser (IE6) and all I see is the source code. The ASP pages are in the folder C:InetpubwwwrootMyFolder

    I'm going <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> . Is it just me? One more thing...be kind I'm new to ASP.

    Thanks,
    John

  10. #10
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: FrontPage Preview (03)

    ASP won't run if you view using that kind of path. Instead, figure out which port your web server responds on. For example, it could be the default port 80. In that case, the page should be served by navigating to:

    http://localhost:80/default.asp

    It has been a long time since I managed an IIS install. However, in the old days, it was done through an MMC Snap-in. I'm not sure how you access that on an XP system, but the Help and Support center says that once IIS is installed, you can get the documentation at:

    http://localhost/iisHelp/

    Does that help?

  11. #11
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    The IIS help page was extremely helpful. I am now able to view and navigate through the tutorial webpages.

    The submission form (asp) is not updating the MS Access database as one would expect. Nothing is being written to the file. There is a "result asp page" which should return what is in the database but alas poor Yorick. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Regards,
    John

  12. #12
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: FrontPage Preview (03)

    I was getting an error that the database was read-only. After much hair pulling, I realized that an ASP application folder is, by default, set to permit the IIS "anonymous user" only Read and Execute privileges. It also needs Write privileges for the MDB file so it can make modifications. After that, the scripts seems to work. Visit the demo site linked above to see one way in which user-inserted script can be thwarted.

  13. #13
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    I tried changing the permissions to read/write and then full control but still can not get it to write to the dbase. I must be missing something. Reading the link again regarding thwarting did not add much value.

    John

  14. #14
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: FrontPage Preview (03)

    I think I need you to describe the exact steps and responses: which page do you start on, what do you do, do you get an error message from ASP/ADO, does the page refresh back to the earlier page or return to the main page (guestbook.asp)? If you perform those same steps at my test site, what do you get?

  15. #15
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FrontPage Preview (03)

    We're talking about a different tutorial which I mention in post 585,872.

    I could not get the guestbook asp to function so I moved along to a tutorial by MSoft. If you don't mind testing the new tutorial, that would be great.

    Thanks,
    John

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •