Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: ASP database not working on Internet

    I made a simple asp site including a MS Access database. Everthing shows fine on my local PC but after uploading to the internet all that happens when you go to the page containing the asp database is I get prompted to download open the file.

    Thank you for any help

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    Can you post the code which is the connection to database?

  3. #3
    Join Date
    Jan 2004
    Posts
    5

    code

    I will show you my site. When you click each pic, you can go to my asp pages, and you can see the code.
    http://home.cogeco.ca/~chiina/profession.htm
    Thank you for your help.

  4. #4
    Join Date
    Oct 2003
    Location
    Belfast
    Posts
    16

    Re: code

    Thats more than likely a problem with your server. You should check with your hosting that they actually supports asp scripts.

    Regards,

    Paul.
    ---------------------------------------
    Make something idiot proof- and someone will make a better idiot
    ----------------------------------------

  5. #5
    Join Date
    Jan 2004
    Posts
    5

    Re: code

    Actually, when I uploaded my asp pages without link to the database, it shows fine, so I was guessing they do have a support for asp hosting.
    When I uploaded the pages with database, it only shows code.
    Do you know why this happens?
    Thank you again for your help.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Can you include a link on your website for the asp page that does work without the database reference ?

  7. #7
    Join Date
    Jan 2004
    Posts
    5

    Link

    This is a link to my asp page which is shown correctly.

    http://home.cogeco.ca/~chiina/testtest.asp

    Thank you.

  8. #8
    Join Date
    Dec 2003
    Posts
    454
    Can you post the code for the files testtest.asp and soaps.asp?

  9. #9
    Join Date
    Jan 2004
    Posts
    5

    code

    What do you mean by that when you say CODE? I am very new to make database website and I am not sure what I am doing here but these are all I can see from testtest.asp and soaps.asp pages sources.

    testtest.asp
    <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
    <html>
    <head>
    <title>Untitled Document</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    </head>

    <body>
    This is a test for asp./
    </body>
    </html>

    soaps.asp
    <%
    // FileName="Connection_odbc_conn_dsn.htm"
    // Type="ADO"
    // DesigntimeType="ADO"
    // HTTP="True"
    // Catalog=""
    // Schema=""
    var MM_Soaps_STRING = "dsn=soaps;"
    %>

    and other asp site starts something like this.

    <%@LANGUAGE="JAVASCRIPT"%>
    <!--#include file="Connections/Soaps.asp" -->
    <%
    var rsUniqueS__MMColParam = "Unique Sculptures";
    if (String(Request("MM_EmptyValue")) != "undefined" &&
    String(Request("MM_EmptyValue")) != "") {
    rsUniqueS__MMColParam = String(Request("MM_EmptyValue"));
    }


    I am making website with Dreamweaver MX so I am not familiar with the code. I am wondering if these site doesn't show on the net because of DSN is not set up correct?

  10. #10
    Join Date
    Oct 2003
    Location
    Belfast
    Posts
    16
    Try this script

    I'm pretty sure your server doesn't support asp. A page saved as ASP with no "code" in it will still display because the html renders however your "database" pages dont because they are using code.

    <%=Response.Write("I support ASP")%>
    ---------------------------------------
    Make something idiot proof- and someone will make a better idiot
    ----------------------------------------

  11. #11
    Join Date
    Oct 2003
    Location
    Belfast
    Posts
    16
    In addition your host is running

    Zeus/4.2 on HP-UX

    Someone more techy will tell us if ASP pages are possible on this platform. Majority of ASP hosting runs Windows.
    ---------------------------------------
    Make something idiot proof- and someone will make a better idiot
    ----------------------------------------

Posting Permissions

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