Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ASP page problem ! help required...

dear all,
wish u a very happny new year..

below is the asp page which i put in my website and provided a link button to open this page but getting error message the internet explorer could not open this page / page has some error. I could not understand that whether the problem is with MSAccess (Acess'97) database or with asp page.


<%
DIM dbobj
Set dbobj = Server.CreateObject("ADODB.Connection")
dbobj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("/sscor.mdb") & ";"
dbobj.Open
dim rs
set rs = Server.CreateObject("ADODB.Recordset")
sqlqry = "SELECT srno,schno,name,add FROM obadd3 ORDER BY name"
rs.open sqlqry,dbobj
Do While Not rs.EOF
%>
<%
rs.MoveNext
Loop
%>




<% = rs.Fields("srno") %>

<% = rs.Fields("schno") %>

<% = rs.Fields("name") %>

<% = rs.Fields("add") %>

Comments

  • FlakesFlakes Member Posts: 642
    : dear all,
    : wish u a very happny new year..
    :
    : below is the asp page which i put in my website and provided a link button to open this page but getting error message the internet explorer could not open this page / page has some error. I could not understand that whether the problem is with MSAccess (Acess'97) database or with asp page.
    :
    :
    : <%
    : DIM dbobj
    : Set dbobj = Server.CreateObject("ADODB.Connection")
    : dbobj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("/sscor.mdb") & ";"
    : dbobj.Open
    : dim rs
    : set rs = Server.CreateObject("ADODB.Recordset")
    : sqlqry = "SELECT srno,schno,name,add FROM obadd3 ORDER BY name"
    : rs.open sqlqry,dbobj
    : Do While Not rs.EOF
    : %>
    :
    :
    :
    : : : : : : <%
    : rs.MoveNext
    : Loop
    : %>
    :
    :
    :
    :


    Try this:

    [code]
    sqlqry = "SELECT srno,schno,[name],[add] FROM obadd3 ORDER BY [name]"

    [/code]


    If you are not getting any detailed error messages, change the settings of your Internet Explorer.

    Go to tools -> Internet Options -> Advanced and *UNCHECK* the "show friendly http error messages" button.




    : <% = rs.Fields("srno") %>
    :

    : <% = rs.Fields("schno") %>
    :

    : <% = rs.Fields("name") %>
    :

    : <% = rs.Fields("add") %>
    :
Sign In or Register to comment.