Previous Next

Thread: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

Last post 06-13-2008 11:10 AM by doaji. 6 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (7 items)

Sort Posts:

  • 06-07-2008, 4:53 PM

    • doaji
    • Not Ranked
    • Joined on 06-07-2008, 4:11 PM
    • Posts 5
    • doaji

    PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    hello everyone,

    please i have been using IIS6 and 5 lately till i got a vista OS, and that comes with IIS7, i would like to know first of all is there is anyway i can install IIS 6 on my vista cos the IIS 7 is a lil more complicated for me.

    the main question however is that i am having problems displaying information from my access database through .asp pages, i havent had this problem with th previous versions, i have gone thru this website to see if there is any info here that can match my prblem but i havent seen any thats why i am posting this.  unlike the previous posted articles i dont recieve error messages, rather if i try to open the .asp page directly, i doesnt open at all, instead it brings up a pop requesting that i download the file, like the asp page is not browseable by the explorer, however when i created a HTML page  and convert it to .asp and include the original .asp page (the one with the codes) that HTML converted page browse but doesnt show anything from the orginal .asp page.

    please i would really appritaite help on this issue as it is really affecting my work

  • 06-08-2008, 11:51 AM In reply to

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    doaji:
    rather if i try to open the .asp page directly, i doesnt open at all, instead it brings up a pop requesting that i download the file

    Did you install ASP Classic?

    Jeff

    Look for Wrox's new book Professional IIS 7 in your local bookstore, or order now at Amazon.com
  • 06-08-2008, 3:25 PM In reply to

    • doaji
    • Not Ranked
    • Joined on 06-07-2008, 4:11 PM
    • Posts 5
    • doaji

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    i have ASP classic

  • 06-08-2008, 10:18 PM In reply to

    • qbernard
    • Top 10 Contributor
    • Joined on 03-26-2003, 2:12 AM
    • Malaysia
    • Posts 2,218
    • IIS MVPs
    • qbernard

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    can you check if the .asp is mapped to ASP handler ? or try reinstall the ASP component. Currently the asp page is serve as html static page.
    Cheers,
    Bernard Cheah
  • 06-09-2008, 1:09 PM In reply to

    • doaji
    • Not Ranked
    • Joined on 06-07-2008, 4:11 PM
    • Posts 5
    • doaji

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    i treid to c if i could find out about the handler, but am afriad i couldnt get around the manager, its a lil complicated for me, i would really appritaite if anyone could show me how to go about finding out if the .asp is mapped to the ASP handler and also how to re install the ASP componet just incase.

    thanks qbernard

    qbernard:
    can you check if the .asp is mapped to ASP handler ? or try reinstall the ASP component. Currently the asp page is serve as html static page.

  • 06-13-2008, 9:05 AM In reply to

    • doaji
    • Not Ranked
    • Joined on 06-07-2008, 4:11 PM
    • Posts 5
    • doaji

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    i have re installed the componet and rigth now its accepting .asp pages, but it still brings up an erro page. and yes the .asp is mapped to the ASP handler.. the error page reads "An error occurred on the server when processing the URL. Please contact the system administrator" please do u have an idea how to tackle this. thanks

    doaji:

    i treid to c if i could find out about the handler, but am afriad i couldnt get around the manager, its a lil complicated for me, i would really appritaite if anyone could show me how to go about finding out if the .asp is mapped to the ASP handler and also how to re install the ASP componet just incase.

    thanks qbernard

    qbernard:
    can you check if the .asp is mapped to ASP handler ? or try reinstall the ASP component. Currently the asp page is serve as html static page.

  • 06-13-2008, 11:10 AM In reply to

    • doaji
    • Not Ranked
    • Joined on 06-07-2008, 4:11 PM
    • Posts 5
    • doaji

    Re: PLEASE I NEED HELP IN DISPLAYIN INFORMATION FROM MS ACCESS THRU .ASP PAGES

    i have spent like 3hrs on research and i must say that i have made great progress, however i got to this point were the error displayed was 80004005 so i made research on that and came across this link http://support.microsoft.com/kb/926939 i followed the steps listed there but i still get same error, please does anyone havean idea of what could be done?

    for details on my script

    I use dreamweaver for this design and when i try the page it shows me error "80004005" and that i should check line 8 of my page so i am pasting from line one to

    <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    <!--#include file="Connections/doaji1.asp" -->
    <%
    Dim Recordset1
    Dim Recordset1_numRows

    Set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.ActiveConnection = MM_doaji1_STRING
    Recordset1.Source = "SELECT * FROM [hot stocks]"
    Recordset1.CursorType = 0
    Recordset1.CursorLocation = 2
    Recordset1.LockType = 1
    Recordset1.Open()

Page 1 of 1 (7 items)
Page view counter